Formatting numbers as dates
- Select the range, row, or column containing the numbers you want to format.
- In the action bar, click Range.
- In the pop-up menu, click Number Format.
- Click the Category box and click Date.
- Click the Format box and click the date format you want.
- To close the pop-up panel, click
.
See also
Why do I need different number formats?
Formatting numbers
Formatting numbers as currency
Formatting numbers as times
Entering a date