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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed from AZ - 30 Jul 2007 16:24 GMT

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

Reply to this Message

Beege - 30 Jul 2007 16:29 GMT

Ed,

Format/Custom/# ??/32

Beege

> 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.
[quoted text clipped - 3 lines]
>
> Ed

Reply to this Message

John Bundy - 30 Jul 2007 16:40 GMT

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

Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> 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.
[quoted text clipped - 3 lines]
>
> Ed

Reply to this Message

Ed from AZ - 30 Jul 2007 16:48 GMT

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

Reply to this Message

Bob Phillips - 30 Jul 2007 17:04 GMT

# ??/32

Signature

---
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.
>
[quoted text clipped - 3 lines]
>
> Ed

Reply to this Message

Ed from AZ - 30 Jul 2007 17:04 GMT

> John and Beege - thanks to both of you.
>
[quoted text clipped - 3 lines]
>
> Ed

Okay - got it!
? ??/32

Thanks for the boost!
Ed

Reply to this Message