Hi all

I inherited a file recently and I have a problem with a cell showing the
formula instead of the calculation.

The formula cell used to be a straight date data entry, and I believe it was
sent to Text format. I now want to change it to =b1, which already has a
manually entered date in it. However, the formula cell will only show =b1.

My sheet is set to auto calculate, and I've tried making sure the cell is a
date format, but it won't change. I've read that changing it to "general",
then f2 and enter, might do the trick. What is that doing? Why doesn't it
calculate if I set it to a date format? If that works, do I need to
re-format it as a date?

Thanks everyone...

--
smither fan