Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date is not permanent | New Users to Excel | |||
change =NOW() to permanent date string | Excel Programming | |||
permanent time and date stamp for Excel --- so it cant be changed | Excel Discussion (Misc queries) | |||
Date format in permanent list | Excel Discussion (Misc queries) | |||
Set Permanent Date Format to MM//DD/YYYY | Excel Discussion (Misc queries) |