# Simplify fractional result of custom number format

In Google Sheets I would like to express any decimal number to the nearest 32nd of an inch. If I type 1.537 I want the result to be 1 17/32, but if I type 1.5 I need it to be expressed as 1 1/2 not 1 16/32 nor 48/32, is there a way to achieve this?

With # ??/32 you are locking it only to "/32" fractions. For variable fractions you need to use:

#??/??

• right I didn't specify but I also need them to output as mixed numbers not improper fractions. If I have 1.5 I like it to show as 1 1/2 not 3/2.
– fred
Jul 22, 2019 at 20:31
• @fred in that case use: # ??/?? - i.stack.imgur.com/9qW8c.png Jul 22, 2019 at 20:41
• This doesn't round to the nearest 32nd as intended, I edited my question to clarify what I mean.
– fred
Jul 23, 2019 at 20:18
• well, you can't have both its either # ??/?? or #??/?? or # ??/32or #??/32 Jul 23, 2019 at 20:19

This worked great for me when I had the same question:
http://dmcritchie.mvps.org/excel/fractex1.htm

Conceptually, round to the closest 1/32 (or whatever fraction you want) and then display format to the simplified fraction.

I used this formula:

=ROUND(A1*32,0)/32

With this display format: # ??/??