Excel 2007 Cell Format Change Bug Warning

[BobLfoot]

Dear All:
I've had this happen four times now on different machines at different times.

Excel 2007 when opening a Shared Workbook and changes all general formatted
cells on all sheets of the workbook to Date Format {mm/dd/yyyy}.

Changing the format back to general only means they again default to date at
the next opening, you must format to text or number to prevent the auto date
format application.

Antbody else been "helped" by this "feature"?

BobLfoot

 

[Carolin]

I have the same problem and been trying to recreate files, but it keeps
happening.

 

[BrettStuart]

Had the same problem on a large spreadsheet I changed to xlsb.

The number formatting for the Style "Normal" had changed to a date format.
Change it back to General.

This doesn't fix the bug that caused the Style "Normal" to change, but it
does give you your spreadsheet back. My Pivot Tables had become a nightmare
as most fields were being displayed as dates, and where they are an input
field, cannot change the field number format.

 

[Nick1111111111111]

I Hvae suddenly got the same problem in an xlsm file. It is a nightmare.
When will Microsfoft propose a solution to this?

Does anyone here know how to fix the default number format for the affected
file?

 

[Buzz95610]

Started seeing this 2 days ago on large spreadsheets with 10-20 tabs > 15MB.
It added a custom format that looked like this "[$-409]d-mmm-yyyy h:mm
AM/PM;@" No idea how it got there. I fixed it by deleting that particular
format and cells went back to General format.

 

[JDebo]

I have been getting this same problem for quite some time. It's very random.
I have not been able to find out why this would happen, if it is something i
am doing, or an excel bug. Some how the "Normal Cell Style" changes to date
format..... Does any one have a fix or can tell us why this happens?

Started seeing this 2 days ago on large spreadsheets with 10-20 tabs > 15MB.
It added a custom format that looked like this "[$-409]d-mmm-yyyy h:mm
AM/PM;@" No idea how it got there. I fixed it by deleting that particular
format and cells went back to General format.

I Hvae suddenly got the same problem in an xlsm file. It is a nightmare.
When will Microsfoft propose a solution to this?

Does anyone here know how to fix the default number format for the affected
file?