Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Abingdon, VA – Tree Cutting & Portable Sawmill

OT Fractions in Excel 2007

Posts

OT Fractions in Excel 2007

#1

OT Fractions in Excel 2007

Tom Rex in TX

I want to display numbers as fractions in their lowest common denominator.

I have thicknesses of lumber that are 3/16, 1/4, 3/8, 3/4, 1 1/4, etc.

To be able to display the 3/16 I have to choose Number, Fraction, as sixteenths.

But I would like the other fractions to diplay as 1/4 (not 4/16) 3/8 (not 6/16) etc.

Is this possible and how do I do it.

Thanks,

T Rex

Re: OT Fractions in Excel 2007

#2

Re: OT Fractions in Excel 2007

Bill Turpin in WNC mountains

Format the column or row as fraction. Click for more fraction options while formatting as fraction. Click on two digits. This will allow 1/4, 3/16, etc.

Re: OT Fractions in Excel 2007

#3

Re: OT Fractions in Excel 2007

Henry Higginbotham

Try:

=ROUND(Formula*16,0)/16

where Formula is the formula you're using that gives you the right answer but with the wrong formatting.

No guarantees, but let me know if it isn't what you're looking for and I'll see if I can make it worse. ;)

Re: OT Fractions in Excel 2007

#4

Oops!  And . . .

Henry Higginbotham

Format the cells as Fraction, Up to two digits (not "As sixteenths")

Re: OT Fractions in Excel 2007

#5

Re: Oops!  And . . .

Tom Rex in TX

That worked.

Thank you