Page 51 - Ones and Zeros 4 (Student Book)

Cell Format

Lesson
Lesson

Some categories have extra options. You can
choose how many decimals a number can have.
You can increase or decrease decimals. You can
also choose the type of date you want to display.
After choosing the recommended formats, your
cells should now look like this:

Cell Formats
Number with 2 decimals 25.23

Date (day of the week is first) Wednesday, October 16, 2019
Currency (Euros) € 150
Percentage with 1 decimal 87.2%
Text 221B Baker Street

5 You can now save the file and exit.

Fun Time!

You can also change the format of a cell from the
‘Number’ menu in the ‘Home’ tab. Move your cursor
over the options to find the ones you used before. What
differences can you notice?
‘Number’ menu

Challenge Yourself!

Now, try to use the ‘Number’ menu to change the format of some cells. Open the file ‘cell
formats 2.xlsx’. Change the format of cells ‘C4:C8’. Use the descriptions on their left.
Use the ‘Number’ menu options this time. When you’re done, the cells should look like
this:
Cell Formats

Number with 3 decimals 54.786
Date (Long Date) Wednesday, October 16, 2019
Currency (British Pound) £ 150.00
Percentage with 2 decimals 87.20%

Text 221B Baker Street

49