And don't use URGENT in the subject, it is likely to do the exact opposite
of its intention and turn people off.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



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