Question About Date Function
 

I know it's basic, but I can't find it in the manual. How can I create the
current date in a cell so that it is the create date of the sheet, and is
not updated every time I open the sheet with the current date? Thanks.

Question About Date Function
 

CTRL-semicolon will insert the date (fixed at that point), Similarly,
CTRL-SHIFT-semicolon (or CTRL-colon) will give you a time-stamp.

Hope this helps.

Pete

On Dec 11, 4:33*pm, "Abradaxis"
wrote:
I know it's basic, but I can't find it in the manual. How can I create the
current date in a cell so that it is the create date of the sheet, and is
not updated every time I open the sheet with the current date? Thanks.

Question About Date Function
 

That is so cool! I looked up three manuals and could not find it anywhere.
The closest I came was a suggestion that I write a macro. Thank you very
much.
"Pete_UK" wrote in message
...
CTRL-semicolon will insert the date (fixed at that point), Similarly,
CTRL-SHIFT-semicolon (or CTRL-colon) will give you a time-stamp.

Hope this helps.

Pete

On Dec 11, 4:33 pm, "Abradaxis"
wrote:
I know it's basic, but I can't find it in the manual. How can I create the
current date in a cell so that it is the create date of the sheet, and is
not updated every time I open the sheet with the current date? Thanks.

Question About Date Function
 

You're welcome - thanks for feeding back.

Pete

On Dec 11, 10:38*pm, "Abradaxis"
wrote:
That is so cool! I looked up three manuals and could not find it anywhere..
The closest I came was a suggestion that I write a macro. Thank you very
much."Pete_UK" wrote in message

...
CTRL-semicolon will insert the date (fixed at that point), Similarly,
CTRL-SHIFT-semicolon (or CTRL-colon) will give you a time-stamp.

Hope this helps.

Pete

On Dec 11, 4:33 pm, "Abradaxis"
wrote:



I know it's basic, but I can't find it in the manual. How can I create the
current date in a cell so that it is the create date of the sheet, and is
not updated every time I open the sheet with the current date? Thanks.- Hide quoted text -

- Show quoted text -

Question About Date Function
 

Easily found in Excel help under "keyboard shortcuts"


Gord Dibben MS Excel MVP

On Fri, 11 Dec 2009 17:38:35 -0500, "Abradaxis"
wrote:

That is so cool! I looked up three manuals and could not find it anywhere.
The closest I came was a suggestion that I write a macro. Thank you very
much.
"Pete_UK" wrote in message
...
CTRL-semicolon will insert the date (fixed at that point), Similarly,
CTRL-SHIFT-semicolon (or CTRL-colon) will give you a time-stamp.

Hope this helps.

Pete

On Dec 11, 4:33 pm, "Abradaxis"
wrote:
I know it's basic, but I can't find it in the manual. How can I create the
current date in a cell so that it is the create date of the sheet, and is
not updated every time I open the sheet with the current date? Thanks.