Monday, January 9th, 2006
Convert It To A Value
Do you have an Excel formula in a single cell that needs to be converting to its value?
No problem. Simple select the cell and press F2 then press F9.
Voila! The cell contains the value of the formula not the formula itself.
Unfortunately, you’ll find that this little trick doesn’t work on multiple cells – so now what?
Tackling this one isn’t as difficult… Continue reading