View Single Post
  #2   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

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.