"Today()"????

I've got the Today() function on an Invoice sheet. I
need to have the date automatically put on the Invoice,
which that function does. But, I need to lock in that
date when the Invoice is saved to file. As it stands now,
the date is updated everytime that file is opened. Is
there a way to do this?

Thanks,

Don

Never mind on this one, I think I've found a way to do
it. Although there might be an easier way, this one
works. I wrote a macro that copied from the Today() cell
and Pasted Special to another cell with "value" checked
in the pop-up window. It works, but always open to
better ways.......

Thanks,

Don
-----Original Message-----
I've got the Today() function on an Invoice sheet. I
need to have the date automatically put on the Invoice,
which that function does. But, I need to lock in that
date when the Invoice is saved to file. As it stands
now,
the date is updated everytime that file is opened. Is
there a way to do this?

Thanks,

Don
.

Hi

Ctrl+Shift+"," on my keyboard - maybe Ctrl+Shift+";" on yours.
PS. The same with "."/":" enters current system time.


--
Arvi Laanemets
(When sending e-mail, use address arvilAttarkon.ee)



wrote in message
...
Never mind on this one, I think I've found a way to do
it. Although there might be an easier way, this one
works. I wrote a macro that copied from the Today() cell
and Pasted Special to another cell with "value" checked
in the pop-up window. It works, but always open to
better ways.......

Thanks,

Don
-----Original Message-----
I've got the Today() function on an Invoice sheet. I
need to have the date automatically put on the Invoice,
which that function does. But, I need to lock in that
date when the Invoice is saved to file. As it stands
now,
the date is updated everytime that file is opened. Is
there a way to do this?

Thanks,

Don
.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Don" schrieb im Newsbeitrag
...
I've got the Today() function on an Invoice sheet. I
need to have the date automatically put on the Invoice,
which that function does. But, I need to lock in that
date when the Invoice is saved to file. As it stands now,
the date is updated everytime that file is opened. Is
there a way to do this?

Thanks,

Don