Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    Texas, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

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

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

    Steve

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    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
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    New Lounger
    Join Date
    Apr 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •