The date January 1, 2021 can be displayed as “1-Jan-20” with the number format: The most important thing to understand about number formats is that they control the display of numbers only – number formats have no effect on underling numeric values. There are quite a few number formats built into Excel, including:

General format Currency format Percentage format Scientific format Date format Time format Custom formats

You can apply number formats from the Home tab of the ribbon:

Excel also allows custom number formats. For a more complete description of custom number format codes see: Custom Number Formats. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Excel Number format - 95