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

Select the area to format, right click-Format Cells go to fraction and that
should do it.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Cyberbiker" wrote:

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

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

"James Silverton" wrote:

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.

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

"James Silverton" wrote in message ...
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 ##/##

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

Beautiful, David!!

Exactly what I needed, Thanks!

"David McRitchie" wrote:

"James Silverton" wrote in message ...
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 ##/##

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

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

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=07b...0TK2MSFTNGXA13


"James Silverton" wrote
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

"David McRitchie" wrote:
=ROUND(A1*16,0)/16 format as 0 ##/##