How to add commas in thousands of numbers in Excel - Knowledge sharing blog

Note: Please read the article carefully before proceeding! If in the process of using you encounter any errors, such as broken download links, slow loading blog, or unable to access a certain page on the blog ... then please inform me here. Thanks!

Yes, in the process of statistics and calculations on the Excel application, you will always face numbers and numerical data values, right?

The fact that your Excel spreadsheet contains long ranges of numbers, without punctuation marks, or commas to separate 3 characters, will make us confused and difficult to work, and can cause errors for users. .

Therefore, in today's tutorial, I would like to introduce to you a little trick, which helps you to separate the numerical values ​​with 3 or more digits on the character field, help you work a more accurate and effective way.

Of course, you can do this manually, but of course I don't encourage you to do so. Instead of the way you will have to manually enter commas or periods, using the Number tool will save you a lot of time in completing an Excel statistics file.

Read more:

How to commas thousands to separate 3-digit numeric values ​​in Excel

+ Step 1: First, open up your Excel file => as you can see in the picture below, by default, the numeric values ​​will be displayed in a series.

+ Step 2: Now you can highlight / scan select the data area containing numbers => and right click => select Format Cells…

+ Step 3: At the dialog box Format Cells => you choose Tab Number => then click on Number.

Next, at the section Decimal places You set the separation ratio is 3 => then click the box Use 1000 Separator (.) => and click OK as the picture to set up.

Ok so you have a table of statistics of characters separated by thousands of dots, or commas.

Very simple and easy is not it. This way we can easily identify and explain long and long sequences without stumbling over the fear of errors.

However, one obvious weakness is that Excel uses both periods and commas to create a separate position for 3 digits. Hopefully in the future, the newly released Excel will overcome this drawback.

Epilogue

Here comes the article How to add commas before thousands of numbers in Excel I would like to pause. Hope this tip will help you in working with Excel file.

Good luck !

CTV: Luong Trung - Blogchiasekienthuc.com

Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!