danny -
Jul 31, 2009 at 06:24 AM - Latest reply: Manoj
- Jan 14, 2013 at 05:51 AM

- Convert date into month name
- Converting date to year and month text [Solved] (Solved) » Forum - Office Software
- Convert date into Month and Year to use > < » Forum - Excel
- Get month name and year from date » Forum - Excel
- Converting Date format in to month format [Solved] » Forum - Android
- Convert Date Format to dd/mm/yyyy in Excel » How-To - 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

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