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) » Forum - Office software
- Convert column date from day month year to year month day (Solved) » Forum - Android
- Converting Date format in to month format » Forum - Android
- Get month name and year from date » Forum - Excel
- Convert date of birth in words » 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

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