Thread: Converting Decimal Ft into Ft & In
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Converting Decimal Ft into Ft & In
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
Reply With QuoteReply With Quote