In Excel the Text formatting formula (=TEXT()) is capible of re-formatting Excel’s built in date storage format.
| Type | Date Example | Result | Formula |
| Full Month Name | 1/25/2016 | January | =TEXT(B2, “mmmm”) |
| Abbreviated Month | 1/25/2016 | Jan | =TEXT(B3, “mmm”) |
| Two digit month number | 1/25/2016 | 01 | =TEXT(B4, “mm”) |
| Single/double month number | 1/25/2016 | 1 | =TEXT(B5, “m”) |
Related search:
- excel text month name
Resources: