Number formats

To change the format of a cell or range, use one of the following methods.

Change the number format through the toolbar

1.Click the Home tab.

2.In the Number format group, perform one of the actions:

•Select the desired format from the drop-down list.

•Click one of the special buttons to quickly apply the format.

•Select Settings from the drop-down list to customize the desired format.

Change the number format via the context menu

1.Right-click on the cell.

2.From the context menu, select Number format.

3.Customize the format.

The format drop-down list displays an example of a number. The current format of the active cell is marked with a check mark. If a range is selected, the format of the first cell is displayed.

For Numeric, Monetary, Financial, Percentage, and Exponential formats, you can quickly increase or decrease the number of decimals.

1.Select a cell or range.

2.On the Home tab, in the Number format group, click the button:

• Increase decimals to add one decimal.

• Decrease decimals to remove one decimal.

When you decrease the decimals, the number in the cell is rounded according to mathematical rules, but the original value is used for calculations.

General

–Purpose: default format. The cell has no special formatting. The application tries to guess the data type (number, date) automatically.

–Features: fractional numbers are displayed without non-significant zeros. If a number does not fit in the cell, it can be rounded for display, but is fully displayed in the formula bar.

Number

–Purpose: For working with regular numbers.

–Settings:

•Digit Group Separator: enables the display of spaces between thousands (e.g., 1,000,000).

•Number of decimal places: the number of digits after the decimal point.

•Negative number format: selects how to display (e.g. -123, (123), in red).

Currency

–Purpose: to display monetary amounts.

–Application: press the ₽ button on the toolbar or select a format from the list.

–Settings: similar to the number format, but with an additional Currency field where you can select a symbol or code ($, €, USD).

–Tip: to quickly apply the format, enter a number followed by the currency symbol (e.g. 95€) and press Enter.

Accounting

–Purpose: for accounting calculations. It differs from the Currency format by aligning the currency symbol to the left edge of the cell and the mandatory display of negative numbers in parentheses (123.45).

–Settings: the same as for the Currency format, except for the format of negative numbers.

Percentage

–Purpose: to display numbers in percentages. The entered value is multiplied by 100 and a % sign is added.

–Usage: click the % button on the toolbar or select a format from the list.

–Settings: you can specify the number of decimals.

Fraction

–Purpose: to display numbers as fractions (e.g. ¼ instead of 0.25).

–Settings: allows you to select the type of fraction (e.g., "one digit" for ½, "two digits" for 25/100).

Scientific

–Purpose: to display very large or very small numbers (e.g. 5.60E+03 instead of 5600).

–Settings: determines the number of decimals.

Date and Time

–Purpose: to display dates and times correctly.

–Usage: the format is often assigned automatically when you enter data similar to date or time.

–Settings: in the Settings window, you can select a locale-independent date and time format. If you select None for one of the components, only the second component will be displayed.

–Important for calculations: dates and times in the application are stored as numbers (date serial numbers), where 1 = January 1, 1900. This allows you to use them in calculations.

Text

–Purpose: to have the application treat the cell contents exactly as text.

–Features: numbers in text format are left-aligned and do not participate in mathematical calculations (for example, in the SUM function). This is useful for phone numbers, codes starting with zero, and other data that should not be calculated.

–See also List of supported currencies.

–See also List of functions.