Working with currencies and dates

Now that you've got the hang of numerical and text data, time to explore dates and currencies! For any value placed into a cell, the spreadsheet will try to determine the correct data type automatically. For example, a cell value starting with $ will automatically be assigned the currency data type.

Sometimes, the data type assigned to the cell value will be incorrect, so you'll have to manually change it to your data type of choice using the Format menu.

Este ejercicio forma parte del curso

Introducción a Google Sheets

Ver curso

Instrucciones de ejercicio

  • Change the format of the dates in D2:D5 from YYYY-MM-DD to M/D/YYYY.
  • Change the date type of the currencies in E2:E5 to the currency (rounded) format.

Ejercicio interactivo práctico

Convierte la teoría en acción con uno de nuestros ejercicios interactivos

Empieza a hacer ejercicio