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.

 

[micnaugh]

Hi all,
I was just wondering if anyone has found anymore information on this bug? It started happening a spreadsheet i use a couple days ago. And it's happened to a few co-workers as well. In our case, though, all the general format cells change to euro currency. Changing it back will only have it revert back to currency on the next open. I've been using this spreadsheet for a year with no problems and all of a sudden, this starts to happen. It almost seems like a virus that infected Excel.

 

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

 

[RegARay]

Buzz 95610 has the answer! I was seeing this also on one of my spreadsheets...I clicked on a (any) cell within the spreadsheet, went to "Format Cell", "Number", "Custom" and found the format that Buzz referred to in his post (following)...

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 deleted this custom format as well as another one: "[$-409]dddd-mmm-yyyy..." and the problem of cells changing formatting from General Text to Date went away!!

I also noticed that I also had another format that was similar (started with the same "[$-409]" but contained the Euro symbol "€" and after I deleted the ""[$-409]d-mmm-yyyy..." formats the one containing the Euro symbol was also gone!!

Thanks Buzz!! RegARay

 

[candy2]

Thank You!!

This solved both of our issues: the date column and the yen problems.

Buzz 95610 has the answer! I was seeing this also on one of my spreadsheets...I clicked on a (any) cell within the spreadsheet, went to "Format Cell", "Number", "Custom" and found the format that Buzz referred to in his post (following)...

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 deleted this custom format as well as another one: "[$-409]dddd-mmm-yyyy..." and the problem of cells changing formatting from General Text to Date went away!!

I also noticed that I also had another format that was similar (started with the same "[$-409]" but contained the Euro symbol "€" and after I deleted the ""[$-409]d-mmm-yyyy..." formats the one containing the Euro symbol was also gone!!

Thanks Buzz!! RegARay

 

[Juleo]

Number Format changing bug

I had a similar problem, Iv'e no idea what caused it, I would change and save the formats and next time I opened the workbook, the format had changed back, the problem was not exclusive to one workbook, I then used "find and replace formats" for all of the workbooks and so far, (touch wood) they seem to be ok

 

[lombos26]

This solved both of our issues: the date column and the yen problems.

Buzz 95610 has the answer! I was seeing this also on one of my spreadsheets...I clicked on a (any) cell within the spreadsheet, went to "Format Cell", "Number", "Custom" and found the format that Buzz referred to in his post (following)...

Thank you so much for this solution!!! I deleted every custom format that it let me. I had recreated my spreadsheet 3 times and was getting frustrated. No one seemed to know what I was talking about (thanks help desk). Anyway it worked! Thanks again!