Formatting numbers using the toolbar

Various formats can be applied to cells. However, the most important in Spreadsheet are the number formats. These will be effective if the cell contains any form of numeric value (including plain numbers, dates, formulas, currencies).

The quickest way to apply number formats is to use the number format buttons on the toolbar, as follows:

image\currency.gif - Add currency format to cell.

image\percent.gif - Add percentage format to cell.

image\commas.gif - Format thousands with comma separator.

image\decincr.gif - Increase number of decimal places by one.

image\decdecr.gif - Decrease number of decimal places by one - the numbers will be rounded to the nearest decimal place.

These buttons can be used together - for example, a cell may contain the number 32. Click on the Currency button, then twice on the Increment precision button, to display $32.00.

For more detailed number formatting, select the Number tab in the "Format" dialog box (select Cells in the Format menu or right-click and select Format Cells).

See:

Formatting a number using the menus