danny - - Latest reply: Manoj - Jan 14, 2013 at 05:51 AM

Related:

- Convert date to month and year in excel
- Converting date to year and month text ✓ - Forum - Office Software
- Convert column date from day month year to year month day ✓ - Forum - Android
- Convert date to month and year - Forum - Excel
- Excel convert date to month and year ✓ - Forum - Excel
- Text format to date/month/year on excel ✓ - Forum - Excel

Best answer

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

A few words of thanks would be greatly appreciated. Add comment

has helped 2562 users this month

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.. :)