Do you have an MS Excel formula in a single cell that needs to be converted to its value?No problem! Simply select the cell, press and release F2 and then press F9.The cell contains the value of the formula and not the formula itself.
Unfortunately, you’ll find that this little trick doesn’t work for multiple cells. [...]
Archive for April, 2008
Convert formula to a Value MS Excel
Posted in Convert formula to a Value MS Excel on April 29, 2008 | Leave a Comment »