Decimal Numbers to Feet and Inches

kimcoloprecast

New Member
Joined
Dec 16, 2003
Messages
7
Is there a way to store a text style that will allow me to convert decimal numbers into feet and inches in the same cell?

I want to be able to type in a number like 3.5 and have it read 3'-6".

Thanks.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
kimcoloprecast said:
Is there a way to store a text style that will allow me to convert decimal numbers into feet and inches in the same cell?

I want to be able to type in a number like 3.5 and have it read 3'-6".

Thanks.

This formula will also convert an entry from a number and decimal to Feet and Inches. However it must be in an adjacent cell.

3.50 3 Feet 6 Inches

=INT(A12)&" Feet"&" "&CONVERT(A12-INT(A12),"ft","in")&" Inches"

or

3.50 3 ' 6 "

=INT(A12)&" '"&" "&CONVERT(A12-INT(A12),"ft","in")&" """
 
Upvote 0
#NAME? Error For Feet and Inch Conversion

That would work even better but I am getting a


#NAME? Error. I copied your formula:

=INT(A12)&" '"&" "&CONVERT(A12-INT(A12),"ft","in")&" """

and put it in cell B12 and then put a number in A12 to convert and that is the error that I get.


Thanks.
 
Upvote 0
I think you also have to load the "Data Analysis" Tool Pak Add In

Under Tools - Add-ins

to use the function "convert"
 
Upvote 0
Re: #NAME? Error For Feet and Inch Conversion

kimcoloprecast said:
That would work even better but I am getting a

#NAME? Error. I copied your formula:

=INT(A12)&" '"&" "&CONVERT(A12-INT(A12),"ft","in")&" """

and put it in cell B12 and then put a number in A12 to convert and that is the error that I get.


Thanks.

You have to go to Tools Add-Ins and click on Analysis Tool Pak. There many kinds of formulas that Excel does not recognize without this Tool Pak.
 
Upvote 0
Welcome to the Board!

See: http://www.mrexcel.com/tip012.shtml

Hope that helps,

Smitty


I'm trying to get this function to work in Excel 2003 and I am experiencing the following difficulties:

1) After following the instructions in the tip012 link, and the follow on comments in this thread I am able to get the function to work initially. After I close out of excel and then return to the sheet the function no longer works:oops:. I get the following error message: "This function takes no arguments." Am I not saving the function in the VBA module correctly?

2) The function shows up as book1.xls!FEET.FEET in the insert function window. I would like to know how to make it read FEET.

Thanks in advance for your help, I'm new to this forum and have ZERO experience with VBA. I can work my way around a spread sheet pretty well but I'm sure the VBA features will make things easier.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

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