How to Display Numbers Without a Comma in Excel 2013

Are some of the numbers in your spreadsheet currently formatted to display commas as a 1000 separator? This is an option in Excel, and it is one that you don’t need to use if you don’t want it.

Our tutorial below will show you how to change the formatting option for cells that are formatted as numbers so that those numbers display in your cells without that comma.


How to Remove the Comma from Numbers in Excel 2013

The steps in this article will show you how to change the formatting for a selection of numbers in your Excel spreadsheet so that those numbers display without a comma.

Step 1: Open your spreadsheet in Excel 2013.


Step 2: Select the cells containing numbers that have commas. You can select an entire row by clicking the row number at the side of the spreadsheet, or you can select an entire column by clicking the column letter at the top of the spreadsheet. You can also select the entire spreadsheet by clicking the gray cell between the row A heading and the column 1 heading.

select the cells with commas in numbers



Step 3: Right-click one of the selected cells, then choose the Format Cells option.

how to change number formatting for cells in excel 2013



Step 4: Choose the Numbers option in the Category column at the left side of the window, then click the box to the left of Use 1000 Separator to remove the check mark from the box. You can then click the OK button at the bottom of the window.

how to remove comma formatting from numbers in excel 2013



Would you like to make negative numbers easier to identify in Excel? Find out how to make negative numbers red, which is a formatting option that Excel will automatically apply to any numerical value that is less than zero. newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.