Excel 2007 Cell Format Change Bug Warning


B

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
 
C

Carolin

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

Advertisements

B

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.
 
N

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

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.
 
Joined
Mar 25, 2009
Messages
1
Reaction score
0
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.
 
Ad

Advertisements

J

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?

Buzz95610 said:
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.


Nick1111111111111 said:
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?
 
Joined
Apr 22, 2009
Messages
1
Reaction score
0
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)...

Buzz95610 said:
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
 
Joined
Dec 10, 2010
Messages
1
Reaction score
0
Thank You!!

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

RegARay said:
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)...

Buzz95610 said:
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
 
Joined
Dec 24, 2010
Messages
1
Reaction score
0
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
 
Ad

Advertisements

Joined
Sep 11, 2012
Messages
1
Reaction score
0
This solved both of our issues: the date column and the yen problems.

RegARay said:
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!:bow:
 

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