# ISNUMBER = FALSE, how do I convert to number?

1. ## 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. ## Re: ISNUMBER = FALSE, how do I convert to number?

=if(isnumber(a1),a1,a1*1)
Does this work?

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

Yes my friend it does, thank you!!

4. ## 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. ## Re: ISNUMBER = FALSE, how do I convert to number?

I do not understand well enough

6. ## 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.

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

Nope.. still can't work this into the vlookup... ugh

8. ## 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. ## 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. ## 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. ## Re: ISNUMBER = FALSE, how do I convert to number?

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

12. ## 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. ## Re: ISNUMBER = FALSE, how do I convert to number?

The simplest solutions are the hardest to find.

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

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

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

#### 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