Inserting static time that doesn't update
 

I need to insert a time in a cell when the adjacent cell changes value.
Everytime I use the NOW() function, all "time" cells update. I need them to
be static.

Inserting static time that doesn't update
 

Instead of:
=NOW()
touch:
CNTRL-SHFT-:

--
Gary''s Student - gsnu200832


"kefee85" wrote:

I need to insert a time in a cell when the adjacent cell changes value.
Everytime I use the NOW() function, all "time" cells update. I need them to
be static.