Change the semicolon to a comma or vice versa

Office 2016 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.

See How to open Control Panel in Windows 10.

   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.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

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.
How to open Control Panel in Windows 10

How to open Control Panel in Windows 10

The Control Panel application is the primary place for various Windows settings controlling Windows looks and feel, and behavior of other software. The Control Panel applets configure field and number separators in Excel (you can switch semicolon to comma, comma to semicolon, comma to point, etc.) or measurement system in PowerPoint.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more