What is a number format?
Track Your Course Progress
You are currently studying as a guest. Your course progress and quiz results will not be saved unless you login to your EduCourse account. Login to track your progress and qualify for your certificate.
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.
