Format the cell as General (or anything but Text)
then select that cell, hit F2, then enter to make excel think you reentered the
formula.

plunk25 wrote:

I have an Excel 2003 spreadsheet with a vlookup formula in it. I created it
using the formula bar and I can see the result in there, but I can only see
the formula on the spreadsheet. I have tried to toggle the formula view
(ctrl+`) and tested other functions (=2+2) to make sure they work...they do.

Any suggestions?

--

Dave Peterson