98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Autodate
Autodate
Resolved · Low Priority · Version 2007
Wed 22 Sep 2010, 16:54Delegate Gary said...
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
Thu 23 Sep 2010, 14:28Trainer Newson said...
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
Thu 23 Sep 2010, 14:30Trainer Newson said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Generating simple column charts1.Select cell range containing data/figures |
