Convert commas to periods in Excel 2016

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

Guide to Changing Commas to Periods in Excel 2016

Excel, developed by American programmers, follows the American standard where periods are used to separate decimals, and commas are used for thousands separators. This contrasts with the Vietnamese convention, causing inconvenience for users. If you're using Excel 2016, learn how to change commas to periods here.

In Vietnamese standard, commas are used to separate the integer and decimal parts in decimal numbers, while periods are used to mark thousands. This is contrary to Excel's default standard.

Therefore, in this article, Mytour will guide you on how to adjust the standard, that is, convert commas to periods for Excel 2016 to align with our country's convention.

Guide to Changing Commas to Periods in Excel 2016

To reset the standard for Excel 2016, follow these steps.

Step 1: Open Excel, select File.

Step 2: In File, navigate to Options.

Step 3: In the Excel Options window, select Advanced.

Step 4: In Advanced, under Editing options, uncheck Use system separators.

Step 5: Below the Use system separators section, make the following changes:

+ Decimal separator (used for decimal points): Replace periods with commas

+ Thousands separator (used for thousands): Replace commas with periods

After making the changes, press OK.

With this, you have successfully changed the default standard, converting commas to periods in Excel 2016. To revert to the old standard, simply go back to Advanced, Editing options, and recheck Use system separators.

Above are the tips on how to change commas to periods in Excel 2016 by Mytour. You can also refer to the article Change commas to periods in Excel 2007. Wishing you success.

Frequently Asked Questions

Why do Excel users in Vietnam face issues with decimal formatting?

Excel follows the American standard, using periods for decimals and commas for thousands. This is contrary to the Vietnamese convention, which causes confusion and inconvenience for users accustomed to the local format.

How can I change decimal and thousands separators in Excel 2016?

To change separators in Excel 2016, go to File > Options > Advanced. Uncheck 'Use system separators' and then set periods as thousands separators and commas as decimal separators before clicking OK.

Is it possible to revert the separator changes made in Excel 2016?

Yes, to revert changes in Excel 2016, navigate back to Options > Advanced, check 'Use system separators' again, and the settings will return to the default American format.

What is the main difference between Excel's default settings and Vietnamese standards?

The primary difference is that Excel uses periods for decimal points and commas for thousands, while Vietnamese standards reverse this, creating challenges for users working with financial or numerical data.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]