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

Thread: Percent format

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to format selected cells to x.xx%. Using the Percent Style, "%", button doesnt format 8.9 to 8.90%, it formats it to 890%.

    Any suggestions? I am trying to use this in a format procedure.

    Thanks!

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

    Default

    I don't know why this is but if you format the cell first, then type in 8.9 you will get 8.90%. If you type the number in first them format the cell it will show 890%. You can go back and retype your number and it will be correct........

    Denny

    [ This Message was edited by: kinkyparamour on 2002-04-27 20:23 ]

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That's right!
    8.9 is 890%
    and 8.9% is .089
    When you format it as % first then what ever you enter Excel multiplies it by 100.

    You can check these out by formatting the number to GENERAL format .. you wil get 890% is 8.9, and 8.9% is 0.089

    HTH
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i've had this happen to me numerous times. if your spreadsheet has a ton of numbers that are like this (mine did) you can do one of two things, either select the whole column and go edit, find, search by 00, replace and leave the replace field blank, it will automatically take out the extra two zero's and still keep it as a number and a percentage. you can also type in a seperat cell 100, copy that, select the column again, right click, paste special, in the middle section of that window say divide. that will also take care of it

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have tried to do some of the mentioned above to no avail. I am trying to format a selection using code to format X.X as X.XX%.

    Does anyone know of any code that I can do this with?

    Thanks for the suggestions.


  6. #6
    Board Regular
    Join Date
    Jul 2002
    Location
    Nurmijärvi, Finland
    Posts
    148
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello waderw.

    Maybe time has passed this question light years, but new Excel users may have same problem. Personally I came up with same problem with imported numbers which I had to format 0.00 %.

    I solved it by using Custom Number Format: In Format Cells Dialog / Number / Custom typing 0.00 "%".

    If somebody knows better way, so let me know.

    Brgds Sir Vili.


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
  •