+ Reply to Thread
Results 1 to 4 of 4

How to show feet inches from decimal?

  1. #1
    Registered User
    Join Date
    09-20-2015
    Location
    Bangladesh
    MS-Off Ver
    Office 2013
    Posts
    8

    How to show feet inches from decimal?

    Hello Everyone,

    I am trying to find this solution for quite long. I am not sure if it's possible. I work a lot with feet and inches dimension in excel. For example i input 1.08 for 1'-1" and 2.92 for 2'-11". I am curious to know is there any way like a custom format to display input of 1.08 like 1'-1" in a cell?

    Thanks in advance

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,693

    Re: How to show feet inches from decimal?

    There are ways, but rather than using 1'-1'' etc. I'd recommend using fractions.
    Ex: if cell holds 1.08
    Apply following custom number format.
    #'-??/12
    It will show as 1'-1/12, while retaining underlying numeric value.

    If you must use 1'-1'' format...
    =INT(A2)&"'-"&ROUND(MOD(A2,1)*12,0)&"''"
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,949

    Re: How to show feet inches from decimal?

    using an approach illustrated by Bo_Ry (another poster)

    - enter custom number format of: 0\' 0\"/12
    - move cursor to highlight / and press CTRL + J
    - click OK
    - enabled word wrap on your cell
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-20-2015
    Location
    Bangladesh
    MS-Off Ver
    Office 2013
    Posts
    8

    Re: How to show feet inches from decimal?

    Quote Originally Posted by XLent View Post
    using an approach illustrated by Bo_Ry (another poster)

    - enter custom number format of: 0\' 0\"/12
    - move cursor to highlight / and press CTRL + J
    - click OK
    - enabled word wrap on your cell
    Thank you for your effort. Really appreciate the help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] (Negative) Feet and inches to Decimal feet
    By atdemeo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-06-2017, 02:38 AM
  2. Converting Feet & Inches to Decimal Inches
    By knavarro01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2016, 02:50 PM
  3. Convert Feet and Inches (Fractions) to Decimal Feet
    By kellser in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2016, 07:16 PM
  4. Convert feet and inches to decimal feet
    By hrg in forum Excel General
    Replies: 12
    Last Post: 04-11-2016, 05:19 PM
  5. Convert Feet and inches to decimal feet
    By Laserdude in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-05-2014, 12:10 AM
  6. [SOLVED] Feet in decimal form to feet/inches
    By devpatel85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2013, 10:18 AM
  7. Convert Decimal Feet to Feet and Inches
    By Surveyour in forum Excel General
    Replies: 6
    Last Post: 10-17-2013, 12:48 PM

Tags for this Thread

Bookmarks

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