Forum Discussion
Excel Regional Settings - list seperater
I am running Office 365 on Windows 10 Professional. I live in South Africa and by default my regional settings have the LIST SEPARATOR as a , (comma) which suits me fine as I am used to using the com...
Compared to your described experience, I am a simple user.
But if you allow, just one thought:
If your language setting is correct, then maybe under Excel Options => Advanced => Edit Options "Adopt separators from operating system" could be deactivated and other separators entered.
If everything is set correctly there, please see this link where several options are described as far as possible.
Formula errors in Excel when list separator is not set correctly
Hope I was able to help you with this information.
Nikolino
I know I don't know anything (Socrates)