autodate

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Autodate

Autodate

resolvedResolved · Low Priority · Version 2007

Gary has attended:
Access Intermediate course
Access Advanced course
Excel Intermediate course
Excel Advanced course

Autodate

How do I stop autodate chaNGING EVERYTIME A DOCUMENT ID OPENED I.E. RETAIN THE DATE THE DOCUMENT WAS CREATED

RE: Autodate

Gary

If you insert dates using Ctrl+ the semi-colon key that will hold the date the document was created and it won't update on opening.

To prevent today updating in workbooks you currently open would I think require a macro written which is beyond the scope of the forum. However I will refer this post to one of our sales team who would be happy to quote you on this. I am sure it wouldn't take much time.

Many thanks

Newson

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Wed 29 Sep 2010: Automatically marked as resolved.


 

Excel tip:

Generating simple column charts

1.Select cell range containing data/figures
2. Press F11

View all Excel hints and tips


Server loaded in 0.11 secs.