Excel Format Cells: Number

(Last Updated On: 2019-09-15)

Formatting Cells is a way of changing the view of of the Cell. All Cells by default is set as general with no specific format being assigned. Although as you would notice Excel tries and figures out the best format like Dates.

To Get to Number Formatting you can right-click on the specified Cell, Row or column and Choose Format Cells… alternatively press CTRL + 1

Format Cells: Number

Number

The Number Category is the first of the explicit options you can choose. The number format is very simplistic with only three options to choose from.

  • Number of Decimal Places
  • 1000 Separator
  • How Negative is being Displayed

The first two is self-explanatory and requires no further explanation. As for the third option has a few sections. The option to choose between the Negative, Brackets or Colors for the negative and any combination there off.

Format Cells: Number

When using the Brackets notice the space on the Negative numbers on the right. This is to allow the numbers to align directly underneath each other.

Format Cells: Number

If you liked what you read Please Share.

I’d love it if you followed me on Twitter and Facebook.

Also, feel free to subscribe to my posts by email. Thanks for reading.

Spread the love

Leave a Reply

Your email address will not be published. Required fields are marked *