How to keep the dates in date format

wen

New Member
Joined
Oct 23, 2002
Messages
1
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
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Travis

Well-known Member
Joined
Feb 26, 2002
Messages
1,711
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

MrExcel MVP
Joined
Feb 18, 2002
Messages
1,030
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

Board Regular
Joined
Oct 22, 2002
Messages
61
A quick way is to hold <Ctrl> and hit the "tilde" key. (the key below the escape key)
 

Forum statistics

Threads
1,143,640
Messages
5,719,984
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top