# Converting Ft/Tenths to Ft/Inches in Decimal form

1. ## Converting Ft/Tenths to Ft/Inches in Decimal form

I am currently needing help converting feet.tenths to feet.inches

I understand the conversion, just not sure how to seperate the number into two parts, since its only the decimal that needs to be multiplied 12, also, if it has to be broken down, a formula to put the number back together in the a cell would be nice.

ie: 3.8, 2.3, 4.8

Thanks, Nic

2. ## Re: Converting Ft/Tenths to Ft/Inches in Decimal form

Hi, and welcome to the forum.

perhaps either
Formula:
`Please Login or Register  to view this content.`

or
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Converting Ft/Tenths to Ft/Inches in Decimal form

This would do but stores the result as text
Formula:
`Please Login or Register  to view this content.`

4. ## Re: Converting Ft/Tenths to Ft/Inches in Decimal form

Try exploiting the DOLLARFR() function.
With
A1: 3.8 <-meaning 3 feet and 8 tenths inches.

This formula converts that value from feet.tenths to feet.twelfths
``Please Login or Register  to view this content.``
In that example, the formula returns: 3.096
read as 3 feet and 9.6 twelfths

8 tenths = 9.6 twelfths

However, if
3.8 literally means 3.8 feet then try this
``Please Login or Register  to view this content.``
which returns: 3.96

Is that something you can work with?

5. ## Re: Converting Ft/Tenths to Ft/Inches in Decimal form

While I was awaiting an answer, I tried a few of my own plug-ins.

Using Column F*

Formula:
`Please Login or Register  to view this content.`

& yes, it was literally feet.

I ran both formulas side by side, & all seems to work.

Thank You for your help Ron.

6. ## Re: Converting Ft/Tenths to Ft/Inches in Decimal form

Glad you got something you can use!

...BTW: If anybody was particularly helpful, you can thank them by clicking the "Add Reputation" star under one of their posts.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1