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

how can I use the NOW() function without it updating thetime?
 

http://www.mcgimpsey.com/excel/timestamp.html

--
Regards,

Peo Sjoblom

Portland, Oregon




"MagicPC" wrote in message
...
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