Dates

[Guest]

I have created a speadsheet that auomatically pops todays date in a cell.
However when I come to open the file a few day later the date changes to
todays date, how can I have auto date when the file is opened but retain that
date when the file is saved?
Any ideas folk?

 

[Stephen]

I have created a speadsheet that auomatically pops todays date in a cell.
However when I come to open the file a few day later the date changes to
todays date, how can I have auto date when the file is opened but retain
that
date when the file is saved?
Any ideas folk?

Ctrl+; (hold down control whilst pressing semi-colon) will enter today's
date as a constant.

 

[Guest]

Rather than use something like:

=TODAY() which changes daily; use:

CNTRL-;

This inserts the current date as a constant. If you open the worksheet a
few days later, it won't change.

 

[Sandy Mann]

To do it automatically you will need VBA. To do it manually press and hold
the Ctrl key while you press the semi-colon key to insert today's date that
will not change.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

Thanks for the help...

Rather than use something like:

=TODAY() which changes daily; use:

CNTRL-;

This inserts the current date as a constant. If you open the worksheet a
few days later, it won't change.