Excel’s Comma Style formats numbers with a thousands separator and a consistent decimal display without adding a currency symbol. It is useful for making large values easier to read while keeping the underlying cells numeric.
Apply Comma Style
- Select the cells containing the numbers.
- Open the Home tab.
- Find the Number group.
- Select Comma Style.
Excel applies the workbook’s accounting-style number format associated with that button, commonly including a thousands separator and decimal places.
Adjust the decimal places
Use the Increase Decimal or Decrease Decimal controls if the default number of decimal places does not fit your data. Displayed rounding does not necessarily change the stored value used by formulas.
Comma Style is not currency formatting
If values represent dollars, euros, pounds, or another currency, use an appropriate Currency or Accounting format so the unit is clear. Comma Style alone does not tell the reader what a number represents.
Separators depend on regional settings
The term “Comma Style” comes from Excel’s interface, but the visible thousands and decimal separators can follow regional conventions. Some locales use periods, spaces, or other characters differently.
If nothing changes
The cells may contain numbers stored as text. Check the imported data before forcing a format; converting identifiers to numbers can remove meaningful leading zeros.
Formatting does not alter formulas
Number formatting changes how a value appears. A formula still calculates from the underlying numeric value, which is why formatting is preferable to manually inserting commas into data.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.