[mso] Re: Excel date
- From: Graham Jones <agjones@xxxxxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Fri, 24 Nov 2006 14:42:45 -0000
Hi Bill
That cell is updating, so it sounds to me like your date is not a static
date being inserted manually?
The following extracted from ExcelXP Help
Insert a static date or time:
Current date Select a cell and press CTRL+;
Current time Select a cell and press CTRL+SHIFT+;
Current date and time Select a cell and press CTRL+; then SPACE then
CTRL+SHIFT+;
Insert a date or time whose value is updated
Use the TODAY and NOW functions to do this task.
Worksheet example
Select the example in the Help topic. Do not select the row or column
headers.
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the Tools menu, point to
Formula Auditing, and then click Formula Auditing Mode.
Formula Description (Result)
=TODAY() Current date (varies)
=NOW() Current date and time (varies)
Note The NOW() and TODAY() functions change only when the worksheet is
calculated or when a macro that contains the function is run. They are not
updated continuously. The date and time used are taken from the computer's
system clock.
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Bill Thurston
Sent: 24 November 2006 14:03
To: mso
Subject: [mso] Excel date
I have a template in Excel with a date cell - - - the date will change to
the current date when I open a saved worksheet - - - I need the date to
remain the saved date not change - - -
Thanks, Bill
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
