+ Reply to Thread
Results 1 to 4 of 4

how to input foot and inches and make it operational

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Matamoros, Mexico
    Posts
    19

    how to input foot and inches and make it operational

    Hello again Guys, i'm bothering you this time because i need to make that excel recognize 4' 2" times 24. I have in A1 4' 2" and in B1 24, but when i do the operation in c1 =a1*b1 it would return me an error message (#value) i guess this is because the numbers may be stored as text.
    how do i make excel to recognize them as numbers?
    what formula can help me in multipy foot and inches times full numbers. I hope you can save me again. Thank you very much mis amigos.

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,583
    Hi Gcastilleja,

    To return the number of feet and inches (in decimal, e.g. 100.25) try this formula in C1:

    Please Login or Register  to view this content.
    If you want to return it to x' yy" again, without using helper columns, this should work:

    Please Login or Register  to view this content.
    I'm sure there's neater formulas out there, but it's what my little brain came up with. VBA could also be used, and I'm pretty sure I've seen examples of doing this somewhere..

    Hope that helps!

  3. #3
    Registered User
    Join Date
    10-02-2008
    Location
    Matamoros, Mexico
    Posts
    19

    thank you very much

    I have not try it yet, because i just logged in, after testing it i will tell you how did it worked. . Muchas gracias Amigo (Thanks a lot my friend).

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,205
    This might give you some more help

    http://www.cpearson.com/excel/FeetInches.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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