+ Reply to Thread
Results 1 to 14 of 14

ISNUMBER = FALSE, how do I convert to number?

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    Salt Lake City
    MS-Off Ver
    2010
    Posts
    84

    ISNUMBER = FALSE, how do I convert to number?

    I get a data pull that is hh:mm:ss but its 'text' and =ISNUMBER i s FALSE. I do a vlookup to pull the numbers, how would I create a convertion formula, I can't reforemat to number it doesn't allow me to.. I've looked through the forum and couldn't find something to do this. If IS NUMBER = FALSE, can it be converted to a number?

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,640

    Re: ISNUMBER = FALSE, how do I convert to number?

    =if(isnumber(a1),a1,a1*1)
    Does this work?
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    Salt Lake City
    MS-Off Ver
    2010
    Posts
    84

    Re: ISNUMBER = FALSE, how do I convert to number?

    Yes my friend it does, thank you!!

  4. #4
    Registered User
    Join Date
    10-04-2013
    Location
    Salt Lake City
    MS-Off Ver
    2010
    Posts
    84

    Re: ISNUMBER = FALSE, how do I convert to number?

    How would i write this into a vlookup like this?

    =IFERROR(if(ISNUMBER(u8),u8,u8*1(VLOOKUP($A8,'Availability '!$B$3:$AI$3265,6,FALSE),"No Data")

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,640

    Re: ISNUMBER = FALSE, how do I convert to number?

    I do not understand well enough
    Post a xls file please

  6. #6
    Registered User
    Join Date
    10-04-2013
    Location
    Salt Lake City
    MS-Off Ver
    2010
    Posts
    84

    Re: ISNUMBER = FALSE, how do I convert to number?

    Here's an example - reference column V the highlighted red column... I want to convert the text using =IF(ISNUMBER(A1)A1,A1,A1*1) Want to use this in the Vlookup formula.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    10-04-2013
    Location
    Salt Lake City
    MS-Off Ver
    2010
    Posts
    84

    Re: ISNUMBER = FALSE, how do I convert to number?

    Nope.. still can't work this into the vlookup... ugh
    Last edited by BenCrockett; 10-18-2013 at 02:19 PM.

  8. #8
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,640

    Re: ISNUMBER = FALSE, how do I convert to number?

    I can't see where it goes wrong.
    where goes it wrong and what value you would expect.

  9. #9
    Registered User
    Join Date
    10-04-2013
    Location
    Salt Lake City
    MS-Off Ver
    2010
    Posts
    84

    Re: ISNUMBER = FALSE, how do I convert to number?

    I am doing a vlookup to get the time, it comes in as text, and I need it to be a number value, because I have to conditional formatting and calculations based off the time.
    Is there a way to convert the text into numbers in the vlookup argument?

  10. #10
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,640

    Re: ISNUMBER = FALSE, how do I convert to number?

    =IFERROR(VLOOKUP($A8;'Availability '!$B$3:$AI$111;10;FALSE)*1;"No Data")
    Try this

  11. #11
    Registered User
    Join Date
    10-04-2013
    Location
    Salt Lake City
    MS-Off Ver
    2010
    Posts
    84

    Re: ISNUMBER = FALSE, how do I convert to number?

    Yup, that worked perfectly, seems too simple haha... thank you very much, Much apprecaited.

  12. #12
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,007

    Re: ISNUMBER = FALSE, how do I convert to number?

    I think you want:

    =IFERROR(VLOOKUP($A8*1,'Availability '!$B$3:$AI$111,10,FALSE),"No Data")

    Hope this helps.

    Pete

  13. #13
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,640

    Re: ISNUMBER = FALSE, how do I convert to number?

    The simplest solutions are the hardest to find.

  14. #14
    Registered User
    Join Date
    10-04-2013
    Location
    Salt Lake City
    MS-Off Ver
    2010
    Posts
    84

    Re: ISNUMBER = FALSE, how do I convert to number?

    Quote Originally Posted by popipipo View Post
    The simplest solutions are the hardest to find.
    That's always the problem with me hah.. Thanks again poppipipo

+ 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