Microsoft Excel cells are pre-formatted to handle different numeric algorithms. In other words Excel cells like to treat entries as numbers. If you try to add a comma to your Excel spreadsheets the commas are often auto-deleted as you type. There is a setting to automatically add commas as thousandths placeholders but you can’t use this setting to add commas in any other capacity, including after letters. If you want to use commas within your cells without having them auto-deleted you need to format the cells as text rather than integers. It doesn’t matter whether the cells contain letters or numbers, formatting as a text entry solves the comma problem.
Open your Excel document and select the cell or cells that you want to use commas in. To select entire rows or columns you can click on the column or row label. You can also hold the “Ctrl” key to select groups of cells individually. As long as you keep the “Ctrl” key pressed down anything you click on becomes part of the selected group.
Click on the “Home” tab at the top of the Excel window.
Click on the “Text” option within the “Number Format” box located on the right side of the window. If this options does not appear within the box scroll down the “Number Format” box until you locate it. Once you click on this formatting option Excel treats all the selected cells as text letting you add commas wherever you please in those cells.
Tips & Warnings
- If you just want to use commas as an automatic thousandths indicator follow steps one and two and click the small arrow in the corner of the “Number” group to open more options. Click the “Use 1000 Separator (,)” check box under the “Number” heading in the new window to enable this formatting.
- Photo Credit Pixland/Pixland/Getty Images