HomeApplicationOffice informationHow to display thousands separator commas in Excel

How to display thousands separator commas in Excel

You often have to work with Excel, enter data for Excel and calculate and process them. Small numbers are easy to read, but large numbers over ten digits are hard to read.

How to display thousands separator commas in Excel Picture 1

You want to display the comma delimited thousands for easy reading. Here's how you can show thousands separator commas in Excel.

How to display thousands separator commas in Excel Picture 2

Step 1: Highlight Cells that need to display the thousands separator in Excel.

How to display thousands separator commas in Excel Picture 3

Step 2: Right-click and select Format Cells (or Ctrl + 1 key combination ).

How to display thousands separator commas in Excel Picture 4

Step 3: In the Format Cells select the Number tab Number , then tick the box before the Use 1000 Separator (,) and press OK .

How to display thousands separator commas in Excel Picture 5

You see the results below:

How to display thousands separator commas in Excel Picture 6

With the above steps, you can display thousands comma separated in Excel. It is very simple and easy to read, no matter how large the number, you don't mind reading them. From now on you can comfortably work with large numbers without worrying about confusion because of the thousands separator.

4 ★ | 1 Vote

You should read it

May be interested

  • How to open files Docx, Xlsx, Pptx on Office 2003Photo of How to open files Docx, Xlsx, Pptx on Office 2003
    how to open docx, xlsx, pptx files in office 2003 - the article shows 3 ways to open files: microsoft office compatibility pack file formats upgrade package, using online websites, using gmail.
  • Convert Word documents to JPG image filesPhoto of Convert Word documents to JPG image files
    convert word documents to jpg image files, if you want to convert word documents into jpg images, you can use doc to image converter software, an easy-to-use software for quick conversion.
  • Turn on and off the Protected View feature in Office 2010, 2013Photo of Turn on and off the Protected View feature in Office 2010, 2013
    in recent versions of office 2010, office 2013 supports the protected view feature. protected view is a feature that only allows you to read documents, helping you avoid malware originating from the internet.
  • Change the measurement unit in Word 2007 2010 2013Photo of Change the measurement unit in Word 2007 2010 2013
    the demand for using word in the drafting is quite large, you want to use for different purposes, and want to use the measurement unit in word, you need to know how to change the measurement unit in word to suit your needs. mine.
  • Set the default font in Word 2007 2010 2013Photo of Set the default font in Word 2007 2010 2013
    before drafting, you usually install the font and font size in the first font. it is simple but if you have to work a lot with word, then setting the font and font size will be very time consuming.
  • Any page numbering in WordPhoto of Any page numbering in Word
    regularly working with word editors, you probably know how to number pages for word documents. but for documents such as dissertations, blueprints, table of contents, opening or ending, it is not usually the page number of the page but only the page number.

Office information