Replace ; with , in functions

E

Emece

When I use functions in Excel, arguments are differentiated by ;

For example =sumif(range;criteria;sum_range)

I want to use , instead of ;

Where can I change it?

Thanks in advance.

Regards,
Emece.-
 
D

Dave Peterson

Excel uses the windows list separator for this character.

In winXP, I'd go into the control panel, regional and language options applet.

Then on the Regional Options tab, click the Customize button.

Then change the list separator (near the bottom) to what you want.

Since this is a windows setting, it'll affect all of windows (which is ok for
me!).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top