Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace ; with , in functions
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.- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace ; with , in functions
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!). Emece wrote: 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.- -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Way do do search/replace on beginning/end of cell w/o functions? | Excel Worksheet Functions | |||
Replace Cells with Column names in functions? | Excel Worksheet Functions | |||
Find replace in functions | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions |