Question About Date Function

  • Thread starter Thread starter Abradaxis
  • Start date Start date
A

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.
 
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
 
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
 
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 -
Click to expand...
 
Back
Top