I actually need to populate the cells automatically first time round only.

The people who are to use the sheet are not very Excel orientated and
therefore the more that can be achieved via automation the better.
"Bob Phillips" wrote:

Use Ctrl-: and Ctrl-Shift-;

--

HTH

RP
(remove nothere from the email address if mailing direct)


"PM" wrote in message
...
I have a spressheet that automatically populates 2 cells with the current
time and date using the TODAY() and NOW () functions. Unfortunately, when
I
go back into the sheet at a later date or time it repopulates the cells
with
the new time and date.

e.g. First Visit date set to 5-Jan 05 and time set to 09:20 AM.
Second visit date set to 5-Jan 05 and time set to 09:25 AM.
Third visit date set to 6-Jan 05 and time set to 10:00 AM.

Is there a way that I can only get the cells populated once?

Any help would be appreciated.