architectural fractions

[Cyberbiker]

I am trying to manipulate imported decimal data and have it show the results
as proper "tape measure" fractions, i.e. n/16, n/8, n/4, or n/2.

If I select say 49.370, I need it to display 49 3/8. I've searched but
haven't seen anything that quite covers this.

TIA

 

[John Bundy]

Select the area to format, right click->Format Cells go to fraction and that
should do it.

 

[James Silverton]

Cyberbiker wrote on Fri, 5 Oct 2007 07:29:02 -0700:

C> If I select say 49.370, I need it to display 49 3/8. I've
C> searched but haven't seen anything that quite covers this.

Have you tried Format Cells as Fractions and chosen eighths?

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[Cyberbiker]

Cyberbiker wrote on Fri, 5 Oct 2007 07:29:02 -0700:

C> If I select say 49.370, I need it to display 49 3/8. I've
C> searched but haven't seen anything that quite covers this.

Have you tried Format Cells as Fractions and chosen eighths?

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

I guess I didn't state what I needed well enough. If I select sixteenths,
then that 49.370 parses as 49 6/16. if I select eighths and the original is
49.060, then it will parse as 49. I'm looking for a code string that will
give the closest "tape measure" fraction, such that the 49.060 would return
49 1/16 and 49.370 would return 49 3/8, etc.

 

[James Silverton]

Cyberbiker wrote on Fri, 5 Oct 2007 08:15:01 -0700:

??>> Cyberbiker wrote on Fri, 5 Oct 2007 07:29:02 -0700:
??>>
C>>> If I select say 49.370, I need it to display 49 3/8. I've
C>>> searched but haven't seen anything that quite covers this.
??>>
??>> Have you tried Format Cells as Fractions and chosen
??>> eighths?
??>>
??>> James Silverton
??>> Potomac, Maryland
??>>
??>> E-mail, with obvious alterations:
??>> not.jim.silverton.at.verizon.not
??>>
If you use sixteenths you get what you want. What have you got
against 6/16?
My tape measure has tenths anyway!


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[David McRitchie]

Cyberbiker wrote on Fri, 5 Oct 2007 08:15:01 -0700:

??>> Cyberbiker wrote on Fri, 5 Oct 2007 07:29:02 -0700:
??>>
C>>> If I select say 49.370, I need it to display 49 3/8. I've
C>>> searched but haven't seen anything that quite covers this.
??>>
??>> Have you tried Format Cells as Fractions and chosen
??>> eighths?
??>>
??>> James Silverton
??>> Potomac, Maryland
??>>
??>> E-mail, with obvious alterations:
??>> not.jim.silverton.at.verizon.not
??>>
If you use sixteenths you get what you want. What have you got
against 6/16?
My tape measure has tenths anyway!

=ROUND(A1*16,0)/16 format as 0 ##/##

 

[Cyberbiker]

Beautiful, David!!

Exactly what I needed, Thanks!

 

[James Silverton]

Cyberbiker wrote on Mon, 8 Oct 2007 03:43:00 -0700:

C> Exactly what I needed, Thanks!

C> "David McRitchie" wrote:
??>>
??>> =ROUND(A1*16,0)/16 format as 0 ##/##
??>>
??>> --
??>> HTH,
??>> David McRitchie, Microsoft MVP -- Excel
??>> My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
??>>

That's a fascinating way to get reduced fractions! I wonder how
did David ever thought of it? It's not intuitive, at least to me



James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[David McRitchie]

You can see the progression in
Fractions rounded to 1/4, 1/8, 1/16, 1/32, 1/64, 1/128
http://www.mvps.org/dmcritchie/excel/fractex1.htm

Started out with some fascinating code from Bernie Deitrick, and that
got major updates a couple of times. But Ron Rosenberg (Jan 25, 2003)
had a simpler way of doing it, and a comment from Harlan Grove to correct
what I'd written for formatting fraction.

Ruler Fractions (Jan 25-27, 2003)
http://google.com/groups?threadm=07bd01c2c48e$9444c450$d6f82ecf@TK2MSFTNGXA13