View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trussman Trussman is offline
external usenet poster
 
Posts: 9
Default How to convert 120608 in Excel into 12 Feet 6 inches 8 sixteenths

I use Excel formulas in the Truss manufacturing industry. (We use a format to
enter Feet, Inches, Sixteenths. 112 equals 1 In., 12 Sxth. [1-3/4"] 10907
equals 1 Ft, 9 In., 7 Sxth. [1' 9-7/16"] )

How can I convert this into a decimal number for calculations? Or how can
this be separated into three cells for manipulation?

Thanks