Share via

Excel 2010 Changes number format after saving

Anonymous
2010-11-19T16:09:37+00:00

When saving an Exel 2010 workbook,  occaisionally Exel will change all the "General" number formats in cells to something else.   In one file, after reopening, it changed them all to "Accounting" format.  In another workbook, it changed them all to "Date" format.   Now I have to go in cell by cell and reformat the entire workbook.   This happens to the ENTIRE workbook (all tabs). Very frustrating --  Is there a fix for this bug?

Note: It started happening when I converted to Excel 2010 from Exel 2007

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-11-19T17:00:03+00:00

Your Normal Style may be corrupted:

Go to Styles in the Home Tab and right-ckick Normal.  Specify modify andcheck the settings and make correction if necessary.

gsnu201005

Was this answer helpful?

100+ people found this answer helpful.
0 comments

19 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-04-26T15:09:52+00:00

    I thought the same as you regarding too many custom style entries, but it happened again yesterday after I had cleaned them out.

    BTW:

    Here is the VBA macro script that you can run to clean up the custome style list.

    Sorry could not indent properly here, but create this in a macro.  A little slow, but works.

    Found this in another forum.

    Sub TrimStyles()

    Dim s As Variant

    Dim g As Style

    On Error Resume Next

    With ActiveWorkbook

    For Each g In .Styles

    If g.BuiltIn = False Then

    s = g.Value

    .Styles(s).Delete

    End If

    Next g

    On Error GoTo 0

    End With

    End Sub

    Greg

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2012-03-21T08:45:58+00:00

    This is causing a major issue now, there seems to be no valid fix for this problem. We will have to think about using another program if Microsoft cannot be bothered to support their customers and fix the bugs in software they are selling.

    POOR SHOW Microsoft I thought you were better than this!!!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2012-03-15T13:47:21+00:00

    This problem is big problem to us, the work round does not seem to help us.

    The number fields are changing to accountancy cells, we have to reformat all of the cells in the spread sheet. Does Microsoft know if the issues about this bug and what timescale have they got to supply a fix for it ?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2010-11-19T17:54:59+00:00

    Thanks,  this worked!   (I reset format back to General). Don't know why this happened twice in two different files but it did correct the problem.

    Thank you!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments