Use the keyboard, Ctrl-****-: (semi-colon)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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