Forum Discussion
Helper VUnable to convert into decimals?
Hi
I have a below column in my table
I am getting the below , when I tried the convert the above column into decimal or fixed decimal in the power query
Decimals values are converted into whole number
Can you please advise what would be the issue? My datasources comes from sql server
bourne2000
The text type column should convert to decimal automatically. Try split by dot then select both columns to merge back with dot.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
bourne2000 , I am assuming you used change datatype.
Is your regional setting is to use . as thousand separator .
It happened with me, I loaded data from the EU region with decimal as ,
after loading , got remove and not decimal was there. As my format is US . is decimal and "," is thousand separater
bourne2000amitchandak yes I changed type. How to change this settings?
bourne2000
The text type column should convert to decimal automatically. Try split by dot then select both columns to merge back with dot.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Johannf78Advocate I
Left-click on the heading of the column you want to convert from text to decimal.
Click on the icon indicating the data type.
Then instead of clicking on "1.2 Decimal value" click on the last item "Using Locale..."
From the Data Type drop-down list select "Decimal Number". From the Locale drop-down list select "English (United States)".
Only this locale works, the outers do not.
