Excel 2007 Changes cell formating after file is saved

J

Jeff Page

I have found in Excel 2007 in some cases when I save and then reopen a file,
the formating of a cell has changed.

It always changes from General (no formatting) to a Date format.

I find i happens most often when the files get large (1meg), and have many
tabs (8+).

It did not happen before in Excel 2003.

I am stumped
 
D

Dan

Has anyone found a solution or cause? I have searched the internet but have
not encountered any more info than what is contained in the previous post.
 
J

JMD

No luck here...I responded to a similar post regarding this issue (see post
"Default Cell Format Changed?" in Excel General Questions). To play it safe I
reverted back to Office 2003 where I never encountered any issues. As
described by Jeff Page, I think the file size and multiple worksheets is
somehow affecting the default cell format.

If you decide to change the cell format back to "General", Excel 2007 will
simply revert the formated cells back to "Date" again. So don't waste your
time! Not finding a simple, quick, and permanent fix is frustrating.

~JMD
 

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

Top