ExcelBanter - Format as an improper fraction

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

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

- - Format as an improper fraction (https://www.excelbanter.com/excel-discussion-misc-queries/158452-format-improper-fraction.html)

hmm

Format as an improper fraction

How do I format a number as an improper fraction; that is, 1 1/2 would show
as 3/2 ?

Mike H

Format as an improper fraction

How about a custom format of

##/##

Mike

"hmm" wrote:

How do I format a number as an improper fraction; that is, 1 1/2 would show
as 3/2 ?

hmm

Format as an improper fraction

Works well Mike.

Can it also suppress the fraction format if the number is an integer
(instead of 2/1, just 2).

"Mike H" wrote:

How about a custom format of

##/##

Mike

"hmm" wrote:

How do I format a number as an improper fraction; that is, 1 1/2 would show
as 3/2 ?

All times are GMT +1. The time now is 08:16 AM.