How to convert YYYYMM to MMYYYY in a cell

[VBAhelp3456]

Hi all

I have some dates in cells formatted as 201212 201304

How do I format the cells so I the date like mm yyyy? so 12/2012 and 04 2012?

Thanks!

[TMS]

Are they real dates? Or just numbers that look like yyyymm? If they are real dates, and you are only displaying the year and month, you could pick another format.

If they're numbers, there's not a lot you can do in the cell, you'd need a formula to swap the elements around.

So, if the "date" is in cell A1, you'd use:

Please Login or Register  to view this content.

. You could then select the formula column and Copy and Paste Special Values over the original.

Regards, TMS

[shg]

You could convert them to dates and then format however you like.

	A	B	C
1	201212	12/2012	B1: =--TEXT(A1, "0000-00-\1")
2	201304	04/2013	Format of B1: mm/yyyy