See

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

for both a function and a VBA solution

--

Regards,

Peo Sjoblom


".:mmac:." <lost@sea wrote in message
...
Thanks for the reply but thats not what I meant.
I meant that the date would pop in automatically when data was entered in
an
adjacent cell.
something like this would be in A1:
= if ((A2 <0)now(), "")
I'm sure the syntax is wrong but it conveys the idea.



"Arvi Laanemets" wrote in message
...
Hi

From Excel Help (Keyboard shortcuts)
CTRL+; (semicolon) Enter the date
CTRL+SHIFT+: (colon) Enter the time



Arvi Laanemets


".:mmac:." <lost@sea wrote in message
...
How can I set a cell to contain the =NOW() date only once when data is
entered in the adjacent cells and not have it update after that?
Right now I copy from a cell that contains =now() and paste value only
into
the cell. Is there an cleaner way?