"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.