Article updated on November 08, 2007

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.

  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.