ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell formatting (https://www.excelbanter.com/excel-discussion-misc-queries/17429-cell-formatting.html)

Wizzer

Cell formatting
 
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

Ron de Bruin

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





All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com