Forum Discussion
Solved
When downloading historical data from Yahoo Finance I am not able to convert text into numbers
Hello, I have an odd issue with the historical data of the company that I have downloaded from the Yahoo Finance. When I try to convert the data from text into decimal numbers using the query editi...
dsmiech See attached. Changed data type using locale for UK that recognises the comma as a thousand separator.
dsmiech Try replacing comma's with nothing. Then Power Query should be able to recognise the values as numbers.
Can't test it right now as I'm not close a computer with PQ.🙂
Unfortunately, but after replacing commas with nothing Power Query is still not recognizing the values as numbers and when I try to convert them the errors still occur.
dsmiech After replacing, did you change the data type to a decimal number or a whole number?
I tried both.
