Date format won't save...?

[Erin]

I have cleared formats, re-formatted, built an entirely new spread and the
format will change, I save it and then when I re-open the spread, it has
converted all the date formatted columns back to General (the serial number)
and the number formatted columns also back to General. Please help!?!

 

[Sheeloo]

Are you working with Excel 2007 and saving in 97-2003 format? If yes, then
while saving you might get an option for recalculating the formulas... I
guess that might be the source of your problem.

You may send the file to me so that I can take a look.

 

[Gord Dibben]

This would usually be caused by some code running.

When you say you built a new spreadsheet do you mean a new workbook?

Maybe some add-in is doing the deed.

Uncheck them all, restart Excel and open your newly formatted workbook.


Gord Dibben MS Excel MVP

 

[Erin]

That is exactly what I was doing but I didn't see an option for recalculating
formulas, where would I find that?

 

[Erin]

Yes, a new workbook. I'm not sure what you mean by 'un-cheking' the
add-ins...?