ExcelBanter - A fraction not converted to Lowest Common Denominator form?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - A fraction not converted to Lowest Common Denominator form? (https://www.excelbanter.com/excel-discussion-misc-queries/137016-fraction-not-converted-lowest-common-denominator-form.html)

Hombrero

A fraction not converted to Lowest Common Denominator form?

How do I format a cell for a fraction without the fraction being converted to
Lowest Common Denominator form?

JE McGimpsey

A fraction not converted to Lowest Common Denominator form?

One way:

Format/Cells/Number/Custom 0 ???/100

or

0 ?/7

etc.

In article ,
Hombrero wrote:

How do I format a cell for a fraction without the fraction being converted to
Lowest Common Denominator form?

All times are GMT +1. The time now is 09:10 AM.