View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.