Converting DD/MM/YYYY to a written Month with a formula?

**JackMWhit** · 02-22-2017, 07:16 AM

So I have a set of around 1500 dates all in the format of DD/MM/YYYY.
I need to get them all to be converted now to just read as the month.

I've attached an example document showing some dates followed by the desired outcome.

Any input is greatly appreciated!

Edit: I was thinking it might be possible to do =TEXT(O2,"M") with a series of IF functions to make it input the date based on the outcome. Might be complicated. Just a thought. (I'm a complete novice with this program)

**southward** · 02-22-2017, 07:26 AM

Hi,

You can achieve this by using a custom format of "mmmm" on the cell.

Here is a website that helps explain:

https://www.ablebits.com/office-addi...number-format/

Hope this is helpful.

Cheers

**JackMWhit** · 02-22-2017, 07:30 AM

Haha I was over-complicating so much! Thank you for your help

+REP

**Phuocam** · 02-22-2017, 07:31 AM

Try :

=TEXT(A2,"mmmm")

**southward** · 02-22-2017, 07:45 AM

You are very welcome.
Glad I could be of some assistance.

Cheers

Converting DD/MM/YYYY to a written Month with a formula?

LinkBack

Thread Tools

Rate This Thread

Display

Converting DD/MM/YYYY to a written Month with a formula?

Re: Converting DD/MM/YYYY to a written Month with a formula?

Re: Converting DD/MM/YYYY to a written Month with a formula?

Re: Converting DD/MM/YYYY to a written Month with a formula?

Re: Converting DD/MM/YYYY to a written Month with a formula?

Thread Information

Users Browsing this Thread

Similar Threads

Converting '(M)M/DD/YYYY' to 'YYYY-MM-DD'? How on earth can it be done!?

Converting dates: YYYY-MM-DD into DD Month YYYY

[SOLVED] Need date formula to convert mm-dd-yyyy or mm/dd/yyyy to dd-mm-yyyy in 1 formula

[SOLVED] Converting dates from dd/mm/yyyy to mm/dd/yyyy

Covert Date DD/MM/YYYY in to month, with the month as text

Copy+Paste macro dd/mm/yyyy to dd/mm/yyyy and NOT dd/mm/yyyy to mm/dd/yyyy

Converting mm/dd/yyyy into yyyy/mm/dd

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions