Change the semicolon to a comma or vice versa

Office 365 2013 2010
This tip is about changing number separators in your system that are used in Excel by default - semicolon to comma, comma to semicolon, comma to point, etc.

If you need to change the separator in Excel without changing system options, please see Change the decimal point to a comma or vice versa.

To change system settings, do the following:

   1.   Open Control Panel.

   2.   In the Control Panel dialog box, choose Change date, time, or number formats:

Control Panel Windows 10

   3.   In the Region dialog box, choose Additional settings...:

Additional settings Windows 10

   4.   In the Customize Format dialog box, choose appropriate List separator or enter the new one:

Customize Format Windows 10

See also this tip in French: Changer le point-virgule en virgule et vice versa.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.