View Single Post
  #4   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

julisimo wrote:
Hi,
First - excuse me for my bad english :)

I want to enter to a cell today() function,
but i don't want the date to change all the time. Example:

Date Time Info Name
01.01.2005 12:45 test Julisimo
01.02.2005 05:32 test2 Ivan

The Date & Time cells - i want to add automatik, but only once.

I hope someone understand me:)
Thanks in advance

----------------------------

Faced with the same problem, I just defined a macro to take care of it.
It just puts today() into the selected cell, then copies that cell and
pastes it back onto itself using the "value only" option. It's easy to
record the macro as you go through the steps, then you've got it.

Good luck...

Bill