A number format is a special code to control how a value is displayed in Excel. For example, the table below shows 7 different number formats applied to the same date, January 1, 2019:
| Input | Code | Result |
| 1-Jan-2019 | Yyyy | 2019 |
| 1-Jan-2019 | Yy | 19 |
| 1-Jan-2019 | Mmm | Jan |
| 1-Jan-2019 | Mmmm | January |
| 1-Jan-2019 | D | 1 |
| 1-Jan-2019 | Ddd | Tue |
| 1-Jan-2019 | Dddd | Tuesday |
The key thing to understand is that number formats change the way numeric values are displayed, but they do not change the actual values.
Go to Next Topic
Course Topic Navigation
Complete all topics and questions to move to the next lesson.