Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Autodate

Resolved · Low Priority · Version 2007

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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

Reply 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.

Excel articles

· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Streamlining Excel To Save Time
· Create An Improvised Bar Chart In Excel
· What Do The Formula Error Messages Mean In Excel?
· Microsoft Excel Training Course

Please browse our web site to find out more about
excel software training and other Microsoft training courses.

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips