Number to feet and inches

D Waggs

Board Regular
Joined
Jun 7, 2004
Messages
61
I need to convert a number to feet and inches with either one decimal place on the inches or even better the fraction. Thanks!!
 
D Waggs said:
I need to convert a number to feet and inches with either one decimal place on the inches or even better the fraction. Thanks!!

I'm not sure if this is what you're after...not too flexible as far as breaking down fractions

=INT(A1/12)&"' "&MOD(A1,12)&"/12"""
 
Upvote 0
I have a number as a decimal in feet and I want that number in feet and inches with the inches in a fraction. I have a formula for getting the number into a 16th fraction

=IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),16)=0,TEXT(B4,"#"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),8)=0,TEXT(B4,"# 0/2"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),4)=0,TEXT(B4,"# 0/4"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),2)=0,TEXT(B4,"# 0/8"),TEXT(B4,"# 0/16")))))

If I enter the number, say 325.28 into A1, I want 325 to show up in A2 and then 3 3/8 to show up in A3. The formula above will take 3.36 (which is .28*12 and display the 3 3/8), I just need to seperate the decimal from the larger number, multiply it by 12 and apply the formula above all in one cell.
 
Upvote 0
If A1 has your number 325.58, then in A2, put the formula:

=INT(A1)

This gives you 325 feet.

For the inches, try this in cell A3:

=TEXT((A1-A2)*12,IF(INT((A1-A2)*12)=(A1-A2)*12,"0","# 0/"&16/GCD(ROUND(16*((A1-A2)*12-INT((A1-A2)*12)),0),16)))

Note that you must have the Cell A2 filled in as above...

HTH,
Mike.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top