View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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 -