I am a draftsman working with steel. I am developing a spreadsheet which
calculates the steel I use. The problem is in converting decimal ft. into
normal ft & inches.

example: Convert 10.4167 into 10'-5"

I tried the CONVERT function but to no avail.

Pls help.

And Thanks, I love the site!

Ed McClelland

=TRUNC(A1)&"'-"&ROUND((A1-TRUNC(A1))*12,1)&""""

If you are looking for a cell format, you could do

format=Cells=custom and use

? ?/12

This would give 10 5/12

--
Regards,
Tom Ogilvy

"Edward McClelland" wrote in message
. ..
I am a draftsman working with steel. I am developing a spreadsheet which
calculates the steel I use. The problem is in converting decimal ft. into
normal ft & inches.

example: Convert 10.4167 into 10'-5"

I tried the CONVERT function but to no avail.

Pls help.

And Thanks, I love the site!

Ed McClelland

Will you ever need 1/4 inch (or fractional inches)?

If yes, then take a look he
http://www.mvps.org/dmcritchie/excel/fractex1.htm



Edward McClelland wrote:

I am a draftsman working with steel. I am developing a spreadsheet which
calculates the steel I use. The problem is in converting decimal ft. into
normal ft & inches.

example: Convert 10.4167 into 10'-5"

I tried the CONVERT function but to no avail.

Pls help.

And Thanks, I love the site!

Ed McClelland

--

Dave Peterson