On Nov 16, 11:05*am, 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.

I just checked that. Even if you have the formula: Today() in a cell
you can type over it and put in any date.
I used: '11Nov89....NOTE: Colon will not show..Semi Colon will
show.Empty cell: I changed my computer date and it stayed the same. as
11Nov89. Unknown if this helps.