Fractions in 16ths format - reducing to LCD
 

I have data in millimeters and converting in aanother cell to inch fractions
in 16ths format (result must be in 16 increments). How do I reduce to LCD - I
do not want to see 8/16 but do want 1/2.
--
Thanks,
Derek

You have an answer elsewhere.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Derek" wrote in message
...
I have data in millimeters and converting in aanother cell to inch
fractions
in 16ths format (result must be in 16 increments). How do I reduce to
LCD - I
do not want to see 8/16 but do want 1/2.
--
Thanks,
Derek

On Thu, 16 Jun 2005 13:33:08 -0700, "Derek"
wrote:

I have data in millimeters and converting in aanother cell to inch fractions
in 16ths format (result must be in 16 increments). How do I reduce to LCD - I
do not want to see 8/16 but do want 1/2.

Round your result to the nearest 16th, and format the cell as a fraction with
up to two digits.

To round:

=ROUND(your_formula*16,0)/16

Format code:

# ??/??


--ron

This works too:

=ROUND(your_formula/16,0)*16

<g

Biff

"Ron Rosenfeld" wrote in message
...
On Thu, 16 Jun 2005 13:33:08 -0700, "Derek"

wrote:

I have data in millimeters and converting in aanother cell to inch
fractions
in 16ths format (result must be in 16 increments). How do I reduce to
LCD - I
do not want to see 8/16 but do want 1/2.

Round your result to the nearest 16th, and format the cell as a fraction
with
up to two digits.

To round:

=ROUND(your_formula*16,0)/16

Format code:

# ??/??


--ron

On Fri, 17 Jun 2005 01:40:53 -0400, "Biff" wrote:

This works too:

=ROUND(your_formula/16,0)*16

<g

To do what?




--ron