# Thread: Feet and Inches (WinME; OXP-SP2)

1. ## Feet and Inches (WinME; OXP-SP2)

Cell formatting can be set to reflect results in many different ways. Is there a format command to set results into feet and inches? For example, a result of 20 if divided by 12 would result in 1' 8". I can only get 1.6666667 for a result. Howcome?

This is such a commonplace issue, I wonder that it's not available in the cell format options.

All input greatly appreciated and gratefully received.

2. ## Re: Feet and Inches (WinME; OXP-SP2)

No direct way. Does this help <post#=39926>post 39926</post#>

Steve

3. ## Re: Feet and Inches (WinME; OXP-SP2)

Hi Bob,

You can get close with a custom format like:
# ??/12
which would give 1 8/12 for your example, if that's any use.

Cheers

4. ## Re: Feet and Inches (WinME; OXP-SP2)

For any length L in inches in cell A2, the following Concatenation-Integer-Mod function yields an equivalent in feet F" and inches I' format:
=INT(A2/12)&""""&" "&MOD(A2,12)&"'"

If L includes a fractional part, the format of the inches component is not controlled and sometimes includes a binary division error fragment. For example, when L = 24.8, {F,I} appears as 2" 0.80000000000001. This may be due to 8/12 = 2/3 = 0.666....

#### Posting Permissions

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