Convert decimal to fraction

[pukenzz]

I know this question has been asked all over the place but I still am not finding the answer I am hoping for…

I want a cell formatted so that it outputs a fraction to the nearest 1/32 of an in or reduces it to the least common denominator. This should happen in the same cell I key it in. So it would be a number format not a cell formula.

It can round up or down to the nearest 32nd
Fraction As sixteenths (8/16) is not precise enough.
Fraction Up to two digits (21/25) does not provide a fraction that would be found on a tape measure.
Custom # ??/32 does not reduce the fraction

And I want it all to happen right in the cell I’m entering the number. I don’t want to have it converted via a formula and result in a different cell.

Also the number should have an “ mark on it. I don’t care how I have to input the number. I’m thinking it would be nice if 22 5/16” could be entered two or three possible ways… 22.3125 or =22+.3125 or 22+5/16.

 

[pukenzz]

Seems like Microsoft has such an obvious miss there.

 

[shg]

I don't think it's a miss at all. Tht's what formulas are for.

 

[pukenzz]

I guess I see it as a miss because they provided the similar formatting for 1/2 1/4 1/8 1/16 but went no further.

 

[shg]

None of those will reduce if you force the denominator.

 

[pukenzz]

Didn't realize that. Thanks!

 

[SpillerBD]

The input could be validated to a multiple of 1/32.
Could the input be automatically changed to a multiple of 1/32 after entry?