Look he

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

BTW don't use phrases like "doesn't work"
Wrong answer? what did you expect and what did you get instead?
Error message? What error message?
Don't see results but see formula?
Cells not recalculating?

Please be specific

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"orquidea" wrote in message ...
| Hi
|
| I want a formula which automaticaly types the current date and time when
| data have been entered in the cell beside. ie.
|
| A B
| DOG =if(A1="",(=NOW()) dd/mm/yy hh:mm
|
| But this one doesn't work.
|
| Could anyone help me please.
|
| Thanks
| Orquidea
|