Different formats can be applied to the numbers that are contained in the cells. The formats affect how the numbers are displayed. For example, numbers can be represented as units of currency, percentages, fractions, time, or date. Some formats allow to configure how negative numbers are represented, divide groups of digits in numbers, and select the number of digits displayed after the decimal point.
Number formats are important for correctly interpreting data in application operations, such as calculations in formulas.
By default, all cells are assigned the General format when documents are created.
To modify the format, do as follows:
1.Select the required cell/range of cells or rows/columns you want to change the format of.
2.Select the desired format from the drop-down list. On the Toolbar, in the Number Format section, click on the field that displays the name of the current format, and select the desired format from the drop-down list.