MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date


Posted by Ayhan KIZILTAN on February 10, 2002 2:39 AM

I designed an order form in excel2000. When the worksheet opened, today's date appears by the now() function. When I reopen the same worksheet in a few days later, it automatically appears as the current days date. I want the date to appear as the date of the day I created the worksheet, not currentdate.

Thanks,

A.KIZILTAN


Posted by Aladin Akyurek on February 10, 2002 2:56 AM

Date stamp the order form by hitting CONTROL and the semi-colon (that is, ";") ath same time instead of =NOW() or =TODAY() functions.