Change argument separator in Excel formulas

[marreco]

Hi.
change is possible somehow to use "," as separator of arguments in Excel formulas, by "/"??

[TABLE="class: grid, width: 261, align: center"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]=VLOOKUP(A2,$I$1:$I$10,1,0)[/TD]
[TD]comma ( , )[/TD]
[/TR]
[TR]
[TD]=VLOOKUP(A2/$I$1:$I$10/1/0)[/TD]
[TD]bar to the right ( / )[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

I don't think it's possible, but I'm curious to know why you'd want to do that ?

 

[marreco]

Hi.
a friend did it, and he can not return to normal.

 

[Jonmo1]

it's probably in Windows Control Panel - regional settings

 

[marreco]

Hi.

Thank jonmo1, do you have any link to and teaches step by step?

 

[Jonmo1]

No, I'm actually just taking an educated guess.

 

[marreco]

ok

thank you!!

 

[Jonmo1]

ok

thank you!!

You're Welcome

 

[axbig]

Hi,
Yes it is possible, by going to "Regional settings" (Regional language) form "Control Panel", selecting "Additional settings..." from the "Formats" tab, and changing the "List separator:" to any separator.

These steps are for Windows 7 users.

 

[Vasco39]

I also tried to change the separator ";" into the separator "," and after a while I've managed. This was done with "windows 10".
First of all:
1 - In excel go to FILE / Options / Advanced / and change in "Editing Options" Decimal separator into "." and Thousands separator into "," because if on your regional settings you are using a comma as the decimal separator, you can't have a comma as the argument separator...
2 - Go to "Control Panel" in Windows, "Clock, Language and Region, and in "Region" go to "Additional settings", change once more the Decimal symbol into "." and further down, at the List separator put the symbol you want. For instance "," "comma".