Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
The DurangoKid
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
The DurangoKid
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format issue CindyLF1 New Users to Excel 3 June 12th 06 06:18 PM
Insert Automatic, Non-Updating Date Stamp Ken Zenachon Excel Discussion (Misc queries) 8 January 18th 06 06:52 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Another Date issue. TimM Excel Worksheet Functions 1 November 17th 05 01:58 AM
Need help troubleshooting an array formula XLXP on Win2K KR Excel Worksheet Functions 1 December 13th 04 07:41 PM


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"