View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to use Today's date in a cell and make it stay the same date

You can use a shortcut key:
ctrl-;
(control semicolon)
to enter the date in the cell.

ADSK wrote:

Hello all

I am working on a purchase order form in Excel 2003. On top of the sheet I
have a cell with the formulla =TODAY() which shows todays date on that cell.
Obviously this is not the correct code for what I need. If I open the file
tomorrow it will show me tomorrows date and thats not what I am after. Is
there a way to get todays date on that cell and make it permanent? For
example, I create a new sheet and automatically I get the date on top and no
matter when I open that sheet again, I get the date that I created that sheet.


--

Dave Peterson