Ask a new question

Query: can't convert to number

Hi 

I made query to pull data from another workbook. I had this error "DataFormat.Error: We couldn't convert to Number". I changed the format to"Text" but it is still showing error.

The data source includes number and text. e.g. 111 & 1A1.

Thanks

Hi,

Share the download link of your workbook.

Regards,

Ashish Mathur
www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

here you go

https://drive.google.com/open?id=0B64seB8-qtdLYk80N3hvX2F6VGc

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi,

At what stage do you get that error?  I could import that data into Power Query with no error message.

Regards,

Ashish Mathur
www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

If you go to data --> From other sources --> From Microsoft query --> Excel Files* --> select this file and add the only column avaialable.

you will get below data which shows empty cell for "090A03249" as below (Cell A10)

Note: I am using different PC now which doesn't have "PowerQuery" so I can't get this error message by now. however, I still the same issue using different approach as above.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi,

You are correct.  Even I face the same problem with MS Query and I do not have a solution to it.  With Power Query a.k.a Data > Get & Transform in Excel 2016, there is no such problem.

Regards,

Ashish Mathur
www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi

I am using Excel 2013, that could be the reason.

Thanks

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 27, 2024 Views 12,299 Applies to: