Question About Date Function

[Abradaxis]

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.

 

[Pete_UK]

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

 

[Abradaxis]

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.
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

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

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

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



- Show quoted text -

 

[Gord Dibben]

Easily found in Excel help under "keyboard shortcuts"


Gord Dibben MS Excel MVP