View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MagicPC
 
Posts: n/a
Default how can I use the NOW() function without it updating thetime?

Hi

I am just trying to get a real time entry into a cell when the cell is
created but I don't want the time to increment as NOW() function does. I just
want it to insert the current time as a static value. How do I do that?

Thanks