Sometimes you want to see the full name of the month Excel. As normal there is more than one way.

Use a custom number format:

To open the Format Cells dialog, in Excel 2007, on the Home tab, click the small (almost invisible) arrow on the bottom right corner of the Number group. In Excel 2000-2003, from the Format menu select Cells and click the Number tab. If you like keyboard shortcuts, CTRL+1 in either version of Excel will bring up the Format Cells dialog. Now, click the Custom category on the left and enter mmmm in the Type field. To display just the first three letters of the month, type mmm instead.

Use function TEXT():

=TEXT(B2,”mmmm”) will return the month’s full name as a text string from a date in cell B2. If you want just the first three letters of the month name, use mmm instead. Also try other combinations of d=day, m=month and y=year (i.e. mmmm d, yyyy).

Also try other combinations of d=day, m=month and y=year (i.e. mmmm d, yyyy) in both the custom date format and the TEXT function.