View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default convert decimal to inch & fraction

Hi!

How small a fraction? To 1/64? 1/128?

Goto FormatCellsNumber tabFraction

From the Type drop down select either:

Up to 2 digits
Up to 3 digits

Biff

"davepatrob" wrote in message
...
CAN YOU FORMAT A CELL TO CONVERT DECIMALS TO INCH & FRACTION OF INCH?