Get fractions in 32nds to quit reducing to different denominators?

[Ed from AZ]

I have a bunch of fractions to input. They are all in 32nds of an
inch. The cells are formatted as Fraction - up to 2 digits.
Unfortunately, "As 32nds" doesn't show as one of the options; so 2/32
automatically reduces to 1/16, 16/32 to 1/2, etc. Can I get
everything to show as 32nds?

Ed

 

[John Bundy]

Change your custom format to this
# ???/32

 

[Ed from AZ]

John and Beege - thanks to both of you.

Unfortunately, I apparently left out one small detail - this renders 1
3/32 as 35/32. I need the major unit along with the fraction. Is
this possible?

Ed

 

[Bob Phillips]

# ??/32

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ed from AZ]

John and Beege - thanks to both of you.

Unfortunately, I apparently left out one small detail - this renders 1
3/32 as 35/32. I need the major unit along with the fraction. Is
this possible?

Ed

Okay - got it!
? ??/32

Thanks for the boost!
Ed