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-02T10:28:37+00:00

    Hi Mu2023,

    Greetings! Thank you for posting to Microsoft Community.

    You can custom it.

    File > option > advanced >Editing options.

    Uncheck "use system separators." Then you can custom it.

    Best Regards,

    Snow Lu

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-02-02T10:42:36+00:00

    Hi, is the change effective for the specific Excel file only? I would appreciate the advise on the specific cells properties change option (is there a suitable cell profile created, or possibility to add the unique cell profile by user)?

    0 comments
  3. Anonymous
    2023-02-02T10:54:02+00:00

    It will be applied on all the files. Could you share some screenshot of your cells? It could be some other workaround.

    0 comments
  4. Anonymous
    2023-02-02T11:07:26+00:00

    Hi, please see the comma replacing error screenshot below: the 9,07 number converts to date format after using replace"," with ".", instead of converting to 9.07

    0 comments
  5. Anonymous
    2023-02-02T11:15:04+00:00

    Could you copy it to a new file and send it to me to check on it?

    You can send file via private message.

    0 comments