EXCEL

  • Thread starter Thread starter Guy Hammond
  • Start date Start date
G

Guy Hammond

Anyone know how to format cells so that decimal
measurements are shown as feet and inches (e.g. 4' 6"")?
 
Go to
http://myweb.cableone.net/twodays/
and download the "Convert Feet..." addin.

When you load the xla, two functions are added:
DFTOS (Decimal Feet to Standard) =DFTOS(YourDigitalMeasurement) and
STODF (Standard to Decimal Feet) =STODF(YourStandardMeasurement)
( It should be notedthe standard feet measurements (such as 12' 9") cannot
be summed; xl sees
them as text; you have to sum as decimal, then convert.
 
Back
Top