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

"Gord Dibben" wrote:

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

On Wed, 17 Dec 2008 08:16:31 -0800, Erin (donotspam)
wrote:

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!?!