Union Operator issues

[cmarkk]

I just had Excel 2010 installed on my new PC and it is using curly brackets as a union operator in formulas rather than the traditional commas. Does anyone know how I can change the union operator to commas?

ie. CONCATENATE(A1{B1{C1) vs. CONCATENATE(A1,B1,C1)

Thanks

 

[pgc01]

Hi
Welcome to the board


That will happen if someone changes the default List Separator character in Windows.

Check the windows control panel:

Control Panel->Region and Language->Formats->Numbers->List separator
If its value is "{", you'll get what you posted.

Please check, and if that's the problem set it to a comma.

Remark: the path to the List separator may not be exactly how I posted, depending on your windows version, but find the List Separator in the regional settings and check it.