There are a number of different ways that a date can be displayed.
The most common way is to use “d” for date, “m” for month and “y” for year.
For example, the 25th December 2015 can be displayed in the following formats:
- dd/mm/yy would display 25/12/15
- dd/mm/yyyy would display 25/12/2015
In the example, the dates are to be changed to display in the dd/yy/mm format.
To change the way a date is displayed.
1. Select the required cells
2. Right click over the selection
3. Select “Format cells”
4. Select the “Number” tab
5. Select the “Date” category
6. Choose the required format
The spreadsheet would now appear as follows:
