Forum Discussion
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 semicolon...
Instead of hardcoding you may keep elements of drop-down list in some table or range. With that you don't depend on regional settings.
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.