Problem: Data in formula can be separated with comma or semicolon. How do i change this setting?
=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.
- Press "Start" button
- Click "Control Panel"
- Click "Regional settings"
- Change location and language to US or UK and english
- Click OK!
Adjusting location and language changes time, language, measurement system and currency also.