Get startedGet started for free

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

View Course

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

Start Exercise