Format toolbar |
|
|
|
Format toolbar |
|
|
Format toolbar |
|
|
|
Format toolbar |
|
|
The Format toolbar lets you determine the formatting of cells in a data sheet (similar to MS Excel functionality):
|
The buttons available on the Format toolbar are also available from the Format menu. The Format menu also provides a number of additional formatting options. |
The table below describes the tools available from the Format toolbar:
Button/function |
Button/function name |
Description |
|
Lets you select a font to apply to selected cell/s. |
|
|
Lets you select a font size to apply to selected cell/s. |
|
|
Bold |
Makes text in selected cell/s bold. |
|
Italics |
Italicise text in selected cell/s. |
|
Underline |
Underline text in selected cell/s. |
|
General Style |
Apply a general number style to selected cell/s. Cells have no specific number formatting applied. |
|
Currency Style (2) |
Display the value of selected cell/s as a monetary value, for example, $1,234.56. Note: By default, XPAC assumes a dollar currency ($). To change the currency symbol, see Number. |
|
Percent Style |
Display the value of selected cell/s as a percentage, for example, 97% (multiples the value by 100). Note: 0.5 displays as 50%, 5 displays as 500%, etc. By default, XPAC assumes a percentage with no decimal spaces. To change the number of decimals that display, see Number. |
|
Date Style |
Display the value of selected cell/s as a date, for example, 15/4/2012. Note: By default, XPAC assumes a date with a DD/MM/YYYY format. To change the date format, see Number. |
|
Comma Style |
Display the value of selected cell/s using a thousands separator, for example, 1,234. |
|
Fixed Style (2) |
Display the value of selected cell/s to be fixed to two decimal places, for example, 1,234.56. |
|
Increase Decimals |
Display more precise values of selected cell/s by using more decimal places. |
|
Decrease Decimals |
Display less precise values of selected cell/s by using fewer decimal places. |
|
Font |
Apply font settings to selected cell/s. See Font for more information. |
|
Repeat Font |
Apply the most recently used font colour to selected cell/s. |
|
Pattern |
Apply a fill colour and/or pattern to selected cell/s. |
|
Repeat Pattern |
Apply the most recently used fill colour (and/or pattern) to selected cell/s. |
