Instead of =NOW() use:

CNTRL-; CNTRL-:
--
Gary''s Student - gsnu200764


"Get System Date & Time" wrote:

I'm trying to use EXCEL to capture transactions. For each transaction record,
I need to get the notebook system date & time. I use the "Now()" function,
but each time I hit enter all the values in the column changes to the current
date & time values. Is there another function/fomulae?