Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ccb/ws
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Paul B
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I turn off the Auto Date function in Excel Tim Excel Worksheet Functions 1 February 15th 06 04:20 PM
Showing todays date when the Excel value is zero David Hall Excel Worksheet Functions 1 January 7th 06 06:19 PM
After concatenating data, how do I get Excel to recognise date? Anisette Excel Discussion (Misc queries) 9 December 29th 05 08:15 PM
the auto date feature is not functioning properly - how to reset E. Ruth Cummins New Users to Excel 3 November 15th 05 03:31 AM
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 03:54 PM


All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"