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. Anonymous
    2023-02-02T11:21:59+00:00

    Hi, it is a common csv type excel file

    0 comments
  2. Anonymous
    2023-02-02T11:45:26+00:00

    It could be raw data is corrupt. Write it in a new workbook and copy/paste on it.

    0 comments
  3. Andreas Killer 144K Reputation points Volunteer Moderator
    2023-02-02T15:32:29+00:00

    Hi, it is a common csv type excel file

    Here is your solution:

    Power Query - How to import a CSV file that does not match your locale - Microsoft Community

    Andreas.

    0 comments
  4. Anonymous
    2023-02-03T08:51:37+00:00

    Hi, my error is opposite, my local settings for numbers do not apply dot.

    0 comments
  5. Andreas Killer 144K Reputation points Volunteer Moderator
    2023-02-03T11:05:36+00:00

    Hi, my error is opposite, my local settings for numbers do not apply dot.

    All you have to do is to change the locale in Power Query to a locale that match the CSV data. Your locale settings doesn't matter anymore after that.

    If you need further help show me your CSV file.

    Andreas.

    0 comments