try,

Ctrl;

Mike

"confused guy and desperately in need !" wrote:

Hi all

i am wondering if there is any way to be able to get a date into the cell
automatically but it stay as it is without being updated after closing and
reopening the file. what i mean is that i want to put some data in one cell
and the other cell shows the date of entery automatically, this part is easy
we can use now() function or even date and so on but the problem is that
these functions get updated (i.e when i come back the next day to the file
what i see is the date of the new day , now is there any way that excel keep
the first date he got from the function as it is ?

that would be a great help indeed.
thanks in advance
M.M