Forum Discussion

Serdar_Akdeniz's avatar
Serdar_Akdeniz
Copper Contributor
Apr 11, 2022

Data validation commas change to semicolons in excel online

I prepared a simple data validation drop-down list in the online version which is shared and used over sharepoint. When the list is in use, the commas I used to seperate the items change to semicolons after a while and it can not seperate the items because, online version uses commas for the job. 

I believe the problem might be someone's computer in the user group is using semicolons for seperation of something, but is there a shortcut to correct it without having to involve with someone else's computer?

Thanks

Serdar

Excel for web
    • Folco's avatar
      Folco
      Copper Contributor
      Feb 19, 2025

      Hello,

      Is it not the job of Excel to manage the regional settings? Your solution works but sounds like a hack to work around an Excel limitation.

      I face the same situation than Serdar_Akdeniz, but it looks like both comma and semicolon works nowadays.

      Anyway I can't find any document which guarantee this behaviour, could someone indicate me some please?

      Thanks in advance.

Resources