Sorry if this is already discussed somewhere but I just can't find it.
I'm basically new to Excel and maybe just don't know how to phase my
question.
Please point me to it if it's there.
Anyway (I'm v7.0 in Office95 PRO if that matters)...

Can I form an "if already there leave it alone otherwise if something is
elsewhere do this" statement? Specifically I'm dealing with [current] date
and time values. I'm trying to capture the date/time I enter something in a
cell.

What I have is:

Date Time v1 v2 v3 Time v1 v2 v3 Time v1 v2 v3 Time v1 v2 v3...

What I'm trying to do is-

. when something is in any Time cell put the current date in the Date
cell [once].
. when something is in a vn cell put the current time in the sets Time
cell [once].

I can get it to appear to work but when I open the file let's say two days
later the dates and times all change to "then" they don't stay as the
intended values of when the data was entered.

Hopefully what I'm trying to do and is happening is clear enough and a
solution exists.

TIA.
gs