Spreadsheets (Using Microsoft Excel)  -  1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21
 Exercise 1  Exercise 2  Exercise 3  Exercise 4
Community Learning Homepage

<< PREVIOUS   9 - Decimals   NEXT >>

To display your numbers as currency i.e. with a pound sign.

1. Click or highlight the required cell or cells.
2. Click the Currency tool on the Formatting toolbar.

Note! If you just want to control the decimal places and do not require the Pound sign then do as follows:

1. Click or highlight the required cell or cells.
1. Click the decrease or Increase decimal tool on the Formatting toolbar.

If you select the decrease option, your numbers will be rounded up to the nearest whole number.

<< PREVIOUS   -   NEXT >>