Learning Objectives
- Change comma style.
At times, you may also wish to use a specific comma style with numbers entered into an Excel worksheet. For example, you may wish “1234” to display as typed or with a comma like “1,234.”
Comma styles are easy to change in Excel using a quick select option in the Number group in the ribbon.
Method 1
When using the Format cell dropdown option from this area, select the “Use 1000 Separator (,)” option to include a comma. You can also choose if you would like any decimal places to be displayed in this same window.
Method 2
The easiest option to include a comma is simply to click on the Comma Style button in the Number group.
When clicking the comma style button, the comma style default is to display numbers with a comma in the thousands place and include two decimal places (Ex: “1200” becomes “1,200.00). This will also change the visible cell styles in the Style” area of the ribbon so you can easily select different options for comma and display format.
Practice question
Below are three different options for comma and display format.
- Comma: Comma with two decimal points
- Comma [0]: Comma with no decimal points
- Currency: Comma with two decimal points and a dollar sign
Practice question