MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Non-Volatile Date


Posted by Simon on September 23, 2001 2:07 AM

HELP!(Please)
How can I convert an automatically generated date ("=today()") to a non volatile text string of the same date, so that when the file is opened at a later date the original date is shown?
This is for dating "date created" info on the spreadsheet. Any assistance greatly appreciated!


Posted by Tom Urtis on September 23, 2001 8:18 AM

Does this help? See 29356.html

Posted by Simon on September 23, 2001 11:58 PM

Yep

Thanks