View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fonz
 
Posts: n/a
Default Using the =NOW() Function

When using =NOW() to have the sheet automatically enter the time and date,
anytime I make a change to the sheet, all the cells with the =NOW() function
update to the current time. Is there any way to get the date and time not to
update once it has appeared in it's assigned cell? Thanks in advance.