Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
5 years ago
Solved

Unable 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 co...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

     

Johannf78's avatar
Johannf78
Icon for Advocate I rankAdvocate I
3 years ago

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.