Forum Discussion
Format Number not accurate
You'll have to investigate a bit further-> "Regional settings is default" . Have a look at the Windows Regional settings, specifically the decimal separator.
Can you test a simpler power query example please? Maybe by duplicating the query, deleting steps to get back to the 'changed type' step ->and changing the data type of 'ext price' to Text then to decimal.
--
You could also experiment by duplicating the column, replacing '.' with ',' and then changing data type to decimal. If that works, it would point to the decimal separator.
I'll wait to hear back from you once these things are done.
You'll have to investigate a bit further-> "Regional settings is default" . Have a look at the Windows Regional settings, specifically the decimal separator.
Can you test a simpler power query example please? Maybe by duplicating the query, deleting steps to get back to the 'changed type' step ->and changing the data type of 'ext price' to Text then to decimal.
--
You could also experiment by duplicating the column, replacing '.' with ',' and then changing data type to decimal. If that works, it would point to the decimal separator.
I'll wait to hear back from you once these things are done.
Hi HotChilli
I replaced the "." with "," and automatically was converted to Text, then change the format to Decimal and it worked.
Thanks a lot!