| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When open document, want date to be current automatically. How?
I want the date to show current date automatically when the document is
opened. I have a document in Word that does this but I do not know how it was done. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When open document, want date to be current automatically. How?
In Excel it is "=NOW()"
Rae wrote: I want the date to show current date automatically when the document is opened. I have a document in Word that does this but I do not know how it was done. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When open document, want date to be current automatically. How?
Are you talking about Excel or Word? In Excel you need either a macro or a
formula =TODAY() will return the computer date In Word it is under insertdate and time and then you need to check "update automatically" -- Regards, Peo Sjoblom "Rae" wrote in message ... I want the date to show current date automatically when the document is opened. I have a document in Word that does this but I do not know how it was done. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When open document, want date to be current automatically. Ho
Thank you, Bob I. Where do I enter that in my spreadsheet?
"Bob I" wrote: In Excel it is "=NOW()" Rae wrote: I want the date to show current date automatically when the document is opened. I have a document in Word that does this but I do not know how it was done. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When open document, want date to be current automatically. Ho
You put it in whichever cell you want to show the date.
And it's =NOW() if you want the cell to contain date and time, or =TODAY() if you just want the date. -- David Biddulph "Rae" wrote in message ... Thank you, Bob I. Where do I enter that in my spreadsheet? "Bob I" wrote: In Excel it is "=NOW()" Rae wrote: I want the date to show current date automatically when the document is opened. I have a document in Word that does this but I do not know how it was done. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When open document, want date to be current automatically. Ho
So, it has to be in a cell at the top of each page or can I have this in the
header/footer option? "David Biddulph" wrote: You put it in whichever cell you want to show the date. And it's =NOW() if you want the cell to contain date and time, or =TODAY() if you just want the date. -- David Biddulph "Rae" wrote in message ... Thank you, Bob I. Where do I enter that in my spreadsheet? "Bob I" wrote: In Excel it is "=NOW()" Rae wrote: I want the date to show current date automatically when the document is opened. I have a document in Word that does this but I do not know how it was done. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically inserting current date in a cell | Excel Discussion (Misc queries) | |||
| Enter current date automatically in filename | Excel Worksheet Functions | |||
| Current date and time updated automatically | Excel Discussion (Misc queries) | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| sum automatically from last 12 months based on current date | Excel Worksheet Functions | |||
Linear Mode
