Forum Discussion
Column from examples incorrect value
- 1 year ago
carmelo73 , Try using
Use Locale Settings: When changing the data type, specify the locale to ensure that Power Query interprets the decimal separator correctly. You can do this by:
Right-clicking the column header.
Selecting "Change Type" > "Using Locale..."
Choosing "Fixed decimal number" and setting the appropriate locale that matches your data's format.
Replace Values: If the text values use a different decimal separator (e.g., a comma ,), you can replace it with a period . before changing the data type:Select the column.
Use the "Replace Values" feature to replace commas with periods.
Then change the column type to "Fixed decimal number".
Hi carmelo73 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.