Change the semicolon to a comma or vice versa

Office 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 choose Change date, time, or number formats:

Control Panel Windows 8

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

Additional settings Windows 8

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

Customize Format Windows 8

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

See Also

How to open Control Panel in Windows 7

How to open Control Panel in Windows 7

This tip is about opening Control Panel in Windows 7 for changing separators in Excel - semicolon to comma, comma to semicolon, comma to point, etc.
Change measurement settings from inches to centimeters and vice versa

Change measurement settings from inches to centimeters and vice versa

The common problem for international teams is different measurement units in different countries. E.g., U.S. is using imperial units like inches and France is using metric units like centimeters. PowerPoint doesn’t allow to embed the measurement settings into the presentation, but you can always change your local Windows settings in order to see the problem from other side.
How to change decimal symbol and digit grouping symbol in Windows 10

How to change decimal symbol and digit grouping symbol in Windows 10

When you work with numbers and amounts in Microsoft Word or Microsoft Excel, you can have some issues with decimal symbol or digit grouping symbol. Both symbols can be changed in the settings of the Windows system.