Results 1 to 3 of 3

Thread: Display ratios

  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello.
    How can I display ratios such as 23/34, 102/200, etc., "as is" in a cell - without Excel reducing them? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you only need them as text, insert an apostrophe before the values, e.g. '23/34. The ' tells Excel to interpret the value as text.

    If you need to use the values in calculations, you can format the cell(s) as a fraction - there is a Fraction category in the Number tab of Format | Cells. But this is limited: you have to specify up to how many digits you want to go, and Excel will simplify the ratios: if you enter 12/48, Excel will simplify it to 1/4.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    The 23/34 in fraction display will not be reduced since it is already reduced. It will change to 2/3 if you want only 1 digit in the denominator (the value of the cell will not change).

    The second (102/200) will always be reduced with 3 digits in the denominator it will dispay as 51/100; with 2 as 25/49 (though the actual number will still be right=0.51)

    If you must have the display show the fraction, but you don't care about the actual number, then add a single quote(') in front of it and excel will presume it is text and not a formula.

    Steve

Posting Permissions

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