Share via

Query: can't convert to number

Anonymous
2017-10-12T23:18:52+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2017-10-12T23:29:40+00:00

    Hi,

    Share the download link of your workbook.

    0 comments
  2. Anonymous
    2017-10-13T00:54:00+00:00
    1 person found this answer helpful.
    0 comments
  3. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2017-10-13T03:34:46+00:00

    Hi,

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

    0 comments
  4. Anonymous
    2017-10-13T03:51:37+00:00

    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 answer helpful.
    0 comments
  5. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2017-10-13T03:58:29+00:00

    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.

    0 comments