|
Home > Archive > MOS > February 2002 > Excel auto date
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| shaxx 2002-01-23, 10:27 am |
| Is there a way to set a cell in excel to automatically enter the current date. There has to be a way but I don't know how.
Thanks,
shax | |
| mlstyles 2002-01-23, 11:40 am |
| Do you mean besides =Today() or =NOW() ? | |
| shaxx 2002-01-23, 12:14 pm |
| Thanks, that's exactly what i needed. | |
| vinnyg101 2002-02-01, 7:34 pm |
| This is good info. I have a follow up to these questions.
Let's say that you use the =Time() or =Now(). Then Excel will record the time or date,time accordingly.
But if you open the workbook the next day won't the time or date change?
How can you make the time or date unchanging. I use these to formulas to keep track of data once it has been entered into a cell. I need to know when the data was enter for my supervisors log. | |
| mlstyles 2002-02-01, 8:19 pm |
| I thought the original purpose was to make the date/time update. Anyhow:
to insert the current date into a cell, use CTRL + ; (semicolon)
to insert the current time into a cell, use CTRL + SHIFT + ; (semicolon)
so, to insert both the current date and time into a cell:
1) use CTRL + ; (semicolon)
2) skip a space
3) then use CTRL + SHIFT + ; (semicolon)
These are all static dates/times and will not update. |
|
|
|
|