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

Thread: Custom Format of a Percent

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

    Default

    i'm having a problem with custom formats for percentages.

    if i have a formula such as =10/100, the result will be .10. as a percent, it will be 10%. how do i get a custom format so that i can get percentage points? basically, i want the result to be 10.0. or even more simply put, i want the answer as a %age, but without the percent sign. please advise.


    han

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Massachusetts
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    by the way, i do NOT want to simply multiply the result by a 100 to get the answer; i want to fix it by using custom formats.

    for example, here's a custom format that changes the number 1,234,567 to 1,234 without dividing by a 1000.
    #,##0,_);(#,##0,)

    thanks in advance.


    han

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
  •