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?

"Sorehead" wrote in message
...
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.

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.
--
Gary''s Student - gsnu200750


"Sorehead" wrote:

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?

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


Replace @mailinator.com with @tiscali.co.uk


"Sorehead" wrote in message
...
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?

Thanks for the help...

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200750


"Sorehead" wrote:

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?