How to Use a Different Decimal Separator in Excel 2013

Depending upon your current geographic location and your field of study, you may be used to a specific character that separates your decimal values. However, the character that is currently set in Microsoft Excel may not be the separator that is ideal for your current needs.

Fortunately you can change the decimal separator in Microsoft Excel 2013 by following a few short steps. You will then be able to set the decimal separator that you want to use for any spreadsheet that you edit in Excel 2013.


How to Switch Decimal Separators in Microsoft Excel

The steps in this guide were performed in Microsoft Excel 2013. The result of completing these steps will be a Microsoft Excel installation that uses a decimal separator of your choosing. Typically this setting is specified by Windows itself, but we will be overriding that setting so that Excel uses the decimal separator that we choose.

Step 1: Open Microsoft Excel 2013.


Step 2: Click the File tab at the top-left corner of the window.

excel 2013 file menu



Step 3: Click the Options button at the bottom of the column on the left side of the window.

open excel options



Step 4: Select the Advanced tab at the left side of the Excel Options window.

advanced tab in excel options menu



Step 5: Scroll down to the Editing section, uncheck the box to the left of Use system separators, then delete the existing character in the Decimal separator field and enter the new one that you want to use. Note that you can also specify the desired Thousands separator as well. Once you are done, click the OK button at the bottom of the window to apply your changes.

how to change the decimal separator in excel 2013



Are you having trouble with a spreadsheet that just won’t print correctly? Read our Excel printing optimization guide for some useful settings and tips that can make the printing process a lot smoother.