Date format won't save...?

  • Thread starter Thread starter Erin
  • Start date Start date
E

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!?!
 
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.
 
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
 
That is exactly what I was doing but I didn't see an option for recalculating
formulas, where would I find that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting a spreadsheet help 4
format number to date 7
Excel Colour code dates 1
Difference between NOW() and TODAY() 9
date format error in cell 1
Peculiar default cell format 1
Analyze with excel (change access date format) 4
Modify general format to date format. 2

Back
Top