This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
how to replace comma with dot without date format error
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi, I changed the regional settings to English (United States) and the amounts still import with comma instead of dot.
Hi, I changed the regional settings to English (United States) and the amounts still import with comma instead of dot.
Naargh, DO NOT CHANGE THE REGIONAL SETTINGS!
Reset the settings of your OS and Excel as shown here:
System settings - How to import a CSV file that does not match your - Microsoft Community
Read my article again how to change the locale in Power Query:
Power Query - How to import a CSV file that does not match your locale - Microsoft Community
After the import of the CSV check if you have real numbers in the cells. If so, anything is okay.
Otherwise show me your CSV.
Andreas.
Hi, without changing the regional settings I get the below result from the 9,81 instead of 9.81
Isn't that logical if the delimiter is set as a comma?
Hi, the comma delimiter is the regional settings, could you kindly advise, how to achieve the 9.81?