Related:

- Excel convert month name to number
- Excel convert number to month - Best answers
- How to get month name from date in excel - Best answers
- How to convert month date year in excel - How-To - Excel
- Excel convert date to general - How-To - Excel
- Excel convert yyyymmdd to date ✓ - Forum - Excel
- Excel - Convert hours in decimal - How-To - Excel
- Excel - Convert numbers to words - How-To - Excel

## 2 replies

Trowa

Danny, did you even try Venkat's solution.

I tried it and it works like a charm, guess you would like to read it again:

Suppose you have 1/1/09 in cell A1,

Then use cell B1 to input this formula: =TEXT(A1,"mmm") .

If you want the full monthname instead of 3 letters add another m,

like this =TEXT(A1,"mmmm") .

Hope it's clear now.

Best regards,

Trowa

I tried it and it works like a charm, guess you would like to read it again:

Suppose you have 1/1/09 in cell A1,

Then use cell B1 to input this formula: =TEXT(A1,"mmm") .

If you want the full monthname instead of 3 letters add another m,

like this =TEXT(A1,"mmmm") .

Hope it's clear now.

Best regards,

Trowa

i m trying to convert my date into month text it shows whole formula in the cell where the formula typed,

my date format is: dd.mm.yyyy

can you plz explain will this formula work on this type of date format?

Once all done convert again number into date column.. :)