1. 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. 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. 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
•