Forum Discussion
Column from examples incorrect value
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".
Super Usercarmelo73 , 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".