excel date format change

April 10, 2010 at 09:58:52
Specs: Windows Vista
Hi, my colleague has saved a lot of our excel files and written 'Today()' (or something like that) instead of just typing the date.

As a consequence, I cannot open a single file without getting today's date when I open them. I would like to be able to open the files, and that the original date is still in place.

Can anyone help me?!

Much appreciated!

Kindest regards


See More: excel date format change

Report •

April 10, 2010 at 14:41:35
The only thing I can think of is to right click the file and select properties, this will show the date created as well as the date modified.
You will need to remove the Today formula and type the date manually using the date created as a reference.
After all there is little efort required to type 10/10/10 only 3 more keystrokes, the cell can be formatted to display it in a more informative form, ie; Sunday Oct 10 2010.

Report •

April 10, 2010 at 19:48:33
Excel questions are best asked in the Office Software forum.

That being said, try this:

Open a new blank instance of Excel


On the Task Bar
Select Tools
Select Options
Select Calculations Tab
Click: Manual
UnClick: Recalculate Before Save
Click OK

Now that the autocalculate is turned off:

On the Task Bar
Click File
Click Open

select the file with the offending =TODAY() formula in it.

Hardcode all the dates and change the formulas.



Report •

Related Solutions

Ask Question