I have a series of numbers that I want to convert to the values shown on an
English ruler so that a carpenter can use them. I can get this to work with
the fraction format if for example the value is 42.375" -- that converts
nicely to 42 3/8" What doesn't work is if the value is 42.333" this
converts to 42 1/3" I would like it to convert to 42 5/16" -- the closest
value on the ruler.

On Wed, 10 Jan 2007 20:15:00 -0800, detroitcarpenterbob
wrote:


I have a series of numbers that I want to convert to the values shown on an
English ruler so that a carpenter can use them. I can get this to work with
the fraction format if for example the value is 42.375" -- that converts
nicely to 42 3/8" What doesn't work is if the value is 42.333" this
converts to 42 1/3" I would like it to convert to 42 5/16" -- the closest
value on the ruler.

Round your value to the nearest 16th, then format as a fraction with "up to two
digits" or # ??/??

=ROUND(A1*16,0)/16


--ron