If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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 |
#2
|
|||
|
|||
"Today()"????
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 . |
#3
|
|||
|
|||
"Today()"????
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 . |
#4
|
|||
|
|||
"Today()"????
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 |
Thread Tools | |
Display Modes | |
|
|