Results 1 to 5 of 5
  1. #1
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Format Cell, Special (2002)

    I'm formating a 3 digit number to a six digit number to produce leading zeros. I use format cell, custom category, and enter 000000 in the Type location. It seems to work right but when I go back into format cell it did not retain the custom category setting but switches to a Special category with a locale of Chinese (PRC). In fact any new workbook I create has that Chinese default. Anyone have an idea of what is going on or how to get rid of the Chinese local?
    You know it's time to diet when you push away from the table and the table moves.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format Cell, Special (2002)

    It's a bizarre example of Excel trying to be intelligent. I don't understand how it could have become your default setting, however - for me it works at the workbook level. You should be able to set the location in the Special category back to English US.

  3. #3
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Format Cell, Special (2002)

    I did try changing the locale back to English and the setting remains that way. Then I go back and set it to the custom category to format a six character value. When that happens it does not keep the "custom" category selection but it once again jumps back to the "special" category with Chinese as the locale. The Type listbox shows 3 items with empty squares as their value. Strange behavior.

    There must be something in Excel or the XP operating system that thinks I'm located in China or using the Chinese language. My Regional / Language settings in the control panel are set to English. Help doesn't give me any other information. But even so, I would not think it should change from "custom" to "special". I'll have to chalk this up as one of those mysteries.
    You know it's time to diet when you push away from the table and the table moves.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format Cell, Special (2002)

    The same happens to me with a Dutch OS and Office version.

  5. #5
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Format Cell, Special (2002)

    Thank you for that confirmation. Trying to understand what's going on though is another thing. Like you mentioned earlier, Excel is trying to act intelligently but I guess I'm not intelligently enough to understand it. I would expect it to remain as a custom category. Oh well. As long as the world goes around or is it me? <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    You know it's time to diet when you push away from the table and the table moves.

Posting Permissions

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