How to keep the dates in date format

[wen]

I have to show the calculation formulas of the spreadsheet. But when I show that with Tool, Option, and Formula under Window Option, the dates in teh same spreadsheet also change to number. E.g. 6/6/1996 became "35222". How can I show the calculation formula without change the dates into numbers?
Please help and thanks in advance.
Wenwen

 

[Travis]

Limited Solution...

This will render your formulas uselss, but if you are just trying to get a printout or something, it will work.

Highlight the whole spreadsheet and do a find and replace all, replacing = with '=

This will accomplish what you want, but you will have to do the opposite to use your formulas again...so dont save it after the changes.

 

[brettvba]

another slightly more sane way is to goto
|Tools|Options|and under window options check the formulas check box this will then show all the formulas instead of the result.

Brett

 

[cspgsl]

A quick way is to hold <Ctrl> and hit the "tilde" key. (the key below the escape key)