Related:

- Excel convert month name to number
- Convert date into month - Best answers
- Convert date to month and year in excel - Best answers
- 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
- Excel convert number to date dd/mm/yyyy - How-To - Excel

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

DON'T MISS

- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- Facebook Code Not Received

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