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.
