View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
detroitcarpenterbob detroitcarpenterbob is offline
external usenet poster
 
Posts: 1
Default how do I show the fractions shown on a ruler?


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.