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