Formatting numbers as dates
  1. Select the range, row, or column containing the numbers you want to format.

  2. In the action bar, click Range.

  3. In the pop-up menu, click Number Format.

  4. Click the Category box and click Date.

  5. Click the Format box and click the date format you want.

  6. To close the pop-up panel, click Pop-up panel close button.



See also
Why do I need different number formats?
Formatting numbers
Formatting numbers as currency
Formatting numbers as times
Entering a date