Data Format Error in Power Query (We could not convert to number. Details: Solarwind.Application)

[aAmirkHan]

Hi,

I am experience challenge while converting data type of column OHR ID into number where it is showing error like "We could not covert to number - Details : Solarwind.Application.

Can you please help me on this error? how can it be fixed?

Thank you 

Kind Regards,

Aamir

[Anonymous]

I bet you are splitting the data in the column to the left of OHR ID, and your delimiter is returning the text "Solarwinds.Application", where you want it to return just a string of numbers. You may want to handle that by using an each if Text.Contains([Column, "Solarwinds.Application" then (split by delimiter and use "Solarwinds.Application" as the delimiter to get whatever text is after that--know what I mean?

--Nate

[PhilipTreacy]

Hi @aAmirkHan 

If the column only consists of text in the form 12345678 then there would be no errors converting that to a number.

Check the ID column for values that are not numeric in form.

regards

Phil

[PhilipTreacy]

Hi @aAmirkHan 

Please supply your file or some sample data.  I can't tell from your image what it is that you are trying to convert.

Regards

Phil

[aAmirkHan]

Hi Philip, 

Thank you for your response, however I can't share you file due to confidentiality in data.

However, I can give you an example in my column of OHR ID it has consist numeric value 12345678.