Change the semicolon to a comma or vice versa

Office 365 2016 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:

Customize Format Windows 8

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.