Problem: Data in formula can be separated with comma or semicolon. How do i change this setting?

Example:
=IF(A1=A2; A1; A2)

=IF(A1=A2, A1, A2)

Solution: This is something you can change in control panel. If you choose US or UK as region, the formula uses commas as separators.

1. Press "Start" button
2. Click "Control Panel"
3. Click "Regional settings"
4. Change location and language to US or UK and english
5. Click OK!

Adjusting location and language changes time, language, measurement system and currency also.

Related posts:

Copy table design settings

How to efficiently summarize data by category and month

Change pivot table data source using a drop down list

Change chart data range using a drop down list (vba)