Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Excel 2010 Random Change to Cells with General Format

    All cells in my file which previously had General format are now formatted as Swedish currency. Is this a known bug? Has anyone else had this happen?

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Anne

    This is impressively weird and unheard of to my knowledge.
    Do you have anyone to blame for messing with your file???
    And is it Kronas or Euros? Doesn't matter really, it just shouldn't happen spontaneously.

    zeddy

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I've done a little more looking, and I've come across references to similar problems. What I see is that the Normal cell style has been changed to the Swedish currency, and this format is then picked up by all cells that have not been explicitly formatted. Now, what I don't know is how/what caused the Normal cell style change. I'm confident that this change wasn't done by either myself or any other user. And further, there is a custom number format for Swedish currency which is now listed as a custom format - not a format that I created.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Anne

    Nasty problem. Seems that this can occur with large spreasheets, particularly those with pivot tables, affects all versions of Excel2003, 2007, 2010.
    Check the entries in your custom formats list: it probably has multiple repeated entries, which you can delete.

    When you copy cells from another workbook into your excel file, it seems that custom formats are possibly 'imported' too. Might be a memory issue when too many custom formats get 'imported'.

    You can 'fix' a corrupted Normal format as follows:
    Click on cell styles in the Home ribbon.
    Right click on "Normal"
    Click Modify
    Click Format
    Change format to General

    Another way would be to remove ALL custom formats from the file.
    You could use the following:

    Sub removeStyles() 'Remove all styles other than Excel's own.

    Dim st As Style

    For Each st In ThisWorkbook.Styles

    If Not st.BuiltIn Then st.Delete

    Next

    End Sub

    let us know how you get on..

    zeddy
    Last edited by zeddy; 2012-02-29 at 06:15.

  5. The Following User Says Thank You to zeddy For This Useful Post:

    AnneD (2012-02-29)

  6. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks for your interest. I have proceeded to change the Normal cell style, and have also killed other unwanted styles with a VBA routine as you suggested. If anyone comes across a cause for this problem, it would be appreciated if they could advise, so it can be avoided. Thanks again.

  7. #6
    New Lounger
    Join Date
    Dec 2009
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Known problem, rumour says it's from copy/paste between different Excel sessions
    see CleanStyles which also resets Builtin styles:
    http://answers.microsoft.com/en-us/o...a-2590343a111d

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •