COMMA separator gone in Formulas

**Gerhard Boshoff** · 01-17-2012, 11:39 AM

Hi.
The Comma does not appear anymore in my basic formula's like before. Due to this I can't even capture basic formula's.

Standard format as I was used to: SUM(number1,[number2],...])
Current format: SUM(number1 [number2] ...)

Only if I press spacebar will the curser jump from number1 to number2, and the result of thwe formula is then Null!.

I do not know if this is only a setting on my machine, or is it Excel 2010?

**TMS** · 01-17-2012, 11:59 AM

Sounds like your keyboard is broken. Can you type commas elsewhere, like in Word?

Regards, TMS

**Gerhard Boshoff** · 01-17-2012, 04:30 PM

Hi. Thanks for the reply.
Yes, I can type comma's ...,,,,,,. No problem with that.
In the meantime, I have checked the same formula's on my home PC where I have used the same Windows 7 as well as the Office 2010 CD's to install. No problem there. I have then reloaded and re-activated my Office package on my Laptop from the CD... Still the same error.

**TMS** · 01-17-2012, 04:37 PM

What language is it using? Can you type ; as a separator?

Regards, TMS

**OnErrorGoto0** · 01-17-2012, 04:41 PM

What regional settings do you have set in Control Panel? It sounds as though you have a space entered as the list separator there.

**Gerhard Boshoff** · 01-17-2012, 05:05 PM

THANKS!!!! Problem solved.... You hit it on the spot! My List separator was set as a space. Now set as comma and all is working fine!!!

**TMS** · 01-17-2012, 05:49 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save