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? |
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? |
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. |
All times are GMT +1. The time now is 04:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com