Let’s take a look.
To start off, let’s copy the numbers in column B to the rest of our table.
Let’s make adjustments to the Number format to match the headings in our table.
By default, the Number format will display two decimal places, rounding numbers as needed.
We can easily change the number of decimal places using buttons on the ribbon.
One button increases decimal places, and the other button decreases decimal places.
The ribbon also has a button that turns on “comma style.”
When clicked, Excel will add a comma to group thousandths for larger numbers.
Finally, Number format has several options for displaying negative numbers.
For example, negative numbers can be displayed in parentheses.
Or, in red.
We can verify this by selecting cells and checking the values displayed in the formula bar.
