Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Format cells

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Iceland
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi everybody!
    When I have a number in a cell (like 1200000)and want to format it to look like 1.200.000. I go to format - number and click on the thousand seperator. What happens is that the number looks like 1200000.0.00 and the negative numbers look like -1.10/.10
    Does anyone know how to change the number format so it looks normal? I've looke in the control panel- regional settings and the settings are all right there but still the numbers in excel look all wrong when I use the thousands separator.
    Can anyone help.... I've been trying to fix this for days....with out luck.
    Thanks a buch....

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary Canada
    Posts
    222
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    go to format - number and decrease "Decimal places" to zero.
    now: 1200000====> 1,200,000

    Good Luck!

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Iceland
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Aryan_hr..... but that's not the solution. It doesn't matter if I change the decimal settings. The number then goes from being 100000.0.00 to 100000.
    So it doesn't seperate by thousands at all the decimal just goes to the back.
    Sigh..... seems like this is unsolvable.
    I've also tried to throw excel out and set it up again.... but it does not change back.
    Anybody???????

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-02-24 07:18, Agga wrote:
    Thanks Aryan_hr..... but that's not the solution. It doesn't matter if I change the decimal settings. The number then goes from being 100000.0.00 to 100000.
    So it doesn't seperate by thousands at all the decimal just goes to the back.
    Sigh..... seems like this is unsolvable.
    I've also tried to throw excel out and set it up again.... but it does not change back.
    Anybody???????
    Did you ever open that workbook on a different machine with an Excel copy of its own in order to see how the formatting then looks like?

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Iceland
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Aladin for your answer...
    I have not tried to open it on my computer at work. I'm afraid that the settings in my homecomputer might scramble the settings in my excel at work. I think that an excel-document from another computer, sent to me via e-mail, scrambled the thousand seperator settings at some point. But I haven't found a way to restore it to the original setting. Do you know of a way?

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Have a look at free ASAP Utilities, downloadable from

    http://www.asap-utilities.com/

  7. #7
    New Member
    Join Date
    Feb 2002
    Location
    Iceland
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks a lot for all your help Aladin.

    I'm sure that these add-ins will come in extremely handy. So if I can't repair the thousand separator.... who cares
    I've got loads of new tools.

    Thanks again for your help... much appreciated.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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