G Guest Jun 14, 2006 #1 How do I prevent the date in a saved excel document from changing to the current date when re-opened at a later time?
How do I prevent the date in a saved excel document from changing to the current date when re-opened at a later time?
P Peo Sjoblom Jun 14, 2006 #2 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
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
G Guest Jun 15, 2006 #3 "Thanks for what now seems to be the obvious ansewr ' no formula'. Couldn't see the forest because my brain was in the way.
"Thanks for what now seems to be the obvious ansewr ' no formula'. Couldn't see the forest because my brain was in the way.
