Page 50 - Ones and Zeros 4 (Student Book)

Cell Format

‘Format Cells’ ‘Number’ tab

increase/decrease decimals

Let’s Learn

Values and labels can be displayed in different ways. According to what a value or a
label represents, we can change its format. This better helps us understand what we
are viewing in a spreadsheet. Cell format is the way we change a number’s appearance
without changing the number itself.

Let’s Practise

Formatting a cell.

1 Open the file ‘Cell Formats.xlsx’.

2 You are going to change the cell format of cells ‘C4:C8’,

according to each description in the cells on their left.

Cell Formats
Number with 2 decimals 25
Date (day of the week is first) 16-10-19

Currency (Euros) 150
Percentage with 1 decimal 0.872
Text 221B Baker Street

3 Right-click on the cell you wish to change

and choose ‘Format Cells’.

4 You are now viewing the ‘Number’ tab.

The list on the left is called ‘Category’. From
this list, you will choose the format of each cell.

48