Forum Discussion
dsmiech
Dec 30, 2020Copper Contributor
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...
- Dec 30, 2020
dsmiech See attached. Changed data type using locale for UK that recognises the comma as a thousand separator.
dsmiech
Dec 30, 2020Copper Contributor
I tried both.
Riny_van_Eekelen
Dec 30, 2020Platinum Contributor
dsmiech See attached. Changed data type using locale for UK that recognises the comma as a thousand separator.
- dsmiechDec 30, 2020Copper Contributor
It works now, thank you very much!
- Riny_van_EekelenDec 30, 2020Platinum Contributor
dsmiech You're welcome!