
Formatting numbers
Several different number formats can be applied to cells by using icons on the
Formatting toolbar. Select the cell, then click the relevant icon. Some icons may not
be visible in a default setup; click the down-arrow at the end of the Formatting bar
and select other icons to display.
Figure 50: Number format icons. Left to right: currency, percentage,
date, exponential, standard, add decimal place, delete decimal place.
In OOo 3.3, numbers formatted with the General number format will display as many
decimal digits as required. In former versions of OOo, a maximum of 2 decimal digits
were displayed with the General number format.
For more control or to select other number formats, use the Numbers tab (Figure 51)
of the Format Cells dialog.
• Apply any of the data types in the Category list to the data.
• Control the number of decimal places and leading zeros.
• Enter a custom format code.
The Language setting controls the local settings for the different formats such as the
date order and the currency marker.
Figure 51: Format Cells > Numbers
Chapter 2 Entering, Editing, and Formatting Data 55
Comentarios a estos manuales