Format dates and numbers
To make your data clear at a glance, in this task you will apply a little bit of formatting to your data.
This exercise is part of the course
Data Visualization in Google Sheets
Exercise instructions
- Format the date so that it shows the day as a number, month in full, and year (e.g. '1 January 2000'). Then widen the column so you can see it all.
- Ensure all numbers have 2 decimal places by highlighting the correct cells, and then using the arrow controls in the toolbar (next to the '123' drop-down menu).
- Note: to pass this exercise you need to use the arrow controls in the toolbar to adjust the decimal places, and not alternative number formatting options.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
