EXCEL

G

Guy Hammond

Anyone know how to format cells so that decimal
measurements are shown as feet and inches (e.g. 4' 6"")?
 
E

EZ Money

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Display a number in feet inches and fractions of and inch 1
Converting measurements 3
change feet and inches to decimal inches 4
calculate square feet 4
feet and inches to meters 4
how do i calculate 2' x 4' x 4" 5
Convert decimals into mm in excel spreadsheet 2

Top