Share via

how to replace comma with dot without date format error

Anonymous
2023-02-02T10:14:38+00:00

how to replace comma with dot without date format error

Microsoft 365 and Office | Excel | For education | Other

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.

0 comments

19 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2023-02-03T16:02:54+00:00

    Hi, the comma delimiter is the regional settings

    It's tearing my hair out, NO IT IS NOT!

    If you setup an import of a CSV file Power Query GUESSES what might be the delimiter:

    This will mostly be correct if the CSV is well structured and has enough data. It is obvious that your CSV does not fulfill this.

    Here is the German data CSV file from my article, try to import that file, you will see that Power Query GUESSES that a semicolon is the delimiter.

    This step has absolutely nothing to do with your regional settings. Okay? ;-)

    Change the delimiter to whatever is in your CSV file, then click Transform Data and follow the steps in my article.

    Andreas.

    0 comments
  2. Anonymous
    2023-02-06T08:36:39+00:00

    Hi, after changing the regional settings, as indicated in the article, and reloading the data there is no change to the 9.81

    0 comments
  3. Andreas Killer 144K Reputation points Volunteer Moderator
    2023-02-06T11:16:23+00:00

    I already told you that the import can not work if you use a comma as delimiter on 2/3/2023 4:28:21 PM, look 3 posts back.

    And I told you to change the delimiter to something else in my last post.

    Last chance: Share your CSV file and I show you how to import the file.

    0 comments
  4. Anonymous
    2023-02-06T11:24:55+00:00

    Hi, are you able to advise to what the delimiter should be changed to obtain the 9.81?

    0 comments