Look at ALL the answers, there is a link in Niek's first answer on how to
implement it

--


Regards,


Peo Sjoblom


"orquidea" wrote in message
...
Hi Niek

Thanks for your previous suggestion.
I want to freeze the time once it has been filled in A. As David said,
with
the current formula the time updates as the sheet is being updated.

Orquidea

"Niek Otten" wrote:

You already have a VBA solution in this thread

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"orquidea" wrote in message
...
| Thanks for your repply.
|
| Exactly. I need the time frozen in A. Would you be able to help me
with the
| VBA solution?
|
| Thanks in advanve.
| Orquidea.
|
| "David Biddulph" wrote:
|
| If you want the current date & time in B if A isn't blank, but you
want B
| blank if A is blank, then you could change your formula to
| =IF(A1="","",NOW())
| but remember that it will continue to show current date and time each
time
| you open or update the sheet.
|
| If you want the value frozen at the time A is filled in, then you'll
| probably need a VBA solution.
| --
| David Biddulph
|
| "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
|
|
|
|