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.