Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do you auto populate the date in excel?
i need the date to change automatically on a daily basis - how do i do this -
i know that you can auto populate the date in WORD so i figured you could do it in EXCEL |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do you auto populate the date in excel?
try =today() in a cell
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "ccb/ws" wrote in message ... i need the date to change automatically on a daily basis - how do i do this - i know that you can auto populate the date in WORD so i figured you could do it in EXCEL |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do you auto populate the date in excel?
Be aware that =TODAY() is volatile......in that if you put it in a file
today, and save the file. When you open the file again it will read the date on the day you open it, not the date it was originally put in the file. Hold the Ctrl key and press the semicolon key to get a date-stamp that will be today, and stay the way you set it no matter when the file is opened again. Vaya con Dios, Chuck, CABGx3 "ccb/ws" wrote: i need the date to change automatically on a daily basis - how do i do this - i know that you can auto populate the date in WORD so i figured you could do it in EXCEL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn off the Auto Date function in Excel | Excel Worksheet Functions | |||
Showing todays date when the Excel value is zero | Excel Worksheet Functions | |||
After concatenating data, how do I get Excel to recognise date? | Excel Discussion (Misc queries) | |||
the auto date feature is not functioning properly - how to reset | New Users to Excel | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |