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

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

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 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
 
# ??/32

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
Click to expand...

Okay - got it!
? ??/32

Thanks for the boost!
Ed
 
Back
Top