Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
unwanted date changes
How do I prevent the date in a saved excel document from changing to the
current date when re-opened at a later time? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
unwanted date changes
By not using a formula, or if you do use circular references with iterations
if you want a time/date stamp http://www.mcgimpsey.com/excel/timestamp.html You can also insert today's date with ctrl + ; which will be fixed -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "The DurangoKid" <The wrote in message ... How do I prevent the date in a saved excel document from changing to the current date when re-opened at a later time? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
unwanted date changes
"Thanks for what now seems to be the obvious ansewr ' no formula'. Couldn't see the forest because my brain was in the way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format issue | New Users to Excel | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |