Forum Discussion
Excel Regional Settings - list seperater
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)
Hi Nikolino
Thank you very much for taking the time to reply. I had already tried your suggestion - but it failed to work on the Windows Home version my son has. What I did do, after I received your reply, was to try this on another laptop that has Windows Home on as well - still the problem persists. I checked the language settings on both my system (Professional) and my sons (Home) - both the same settings. It might have something to do with the Home version being Single Language??
Hopefully will find a solution soon!
This is the last information I was able to find.
Sorry for not helping you.
To restore all features of Office, you'll need to fix the problem that's causing activation to fail.
Unlicensed Product and activation errors in Office
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Thank you for your assistance - I have found the solution.
I set the Region to South Africa BUT had to set the Regional Format to English(United States)
I am pleased that you came to a solution.
I also wish you a lot of fun with Excel.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)