Number Format

The general display of numbers. We can specify the number of decimal places that we want to use, we want to use a thousand separator, and how we want to display negative numbers.

  1. Select a cell or a cells range.
  2. Right-Click, Select “Format Cells”
  1. Select “Number”.
    Or Press “CTRL + 1” and select “Number” Tab.
  1. For the number of decimal places, We can change it from the “Decimal places” tab.
  1. We can use a thousand separator (,).
  1. From the “negative number” box, Specify how to display negative numbers.