Periodically, all my formulas show the formula rather than
the result. I've tried changing the cell format but it
doesn't revert. I have to close the file without saving
and then reopen. What causes this and how can I revers it?

Thanks

Try

Ctrl ~

http://www.rondebruin.nl/print.htm#Formulas



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Wizzer" wrote in message ...
Periodically, all my formulas show the formula rather than
the result. I've tried changing the cell format but it
doesn't revert. I have to close the file without saving
and then reopen. What causes this and how can I revers it?

Thanks