How to change date as general "200306" to date "06/2003"

D

Delwyn

I recieve data with a date formated as general that looks like "200306". I
need to change it to a date format that looks like this "06/2003"

How do I do this
 
E

Earl Kiosterud

=DATE(LEFT(A2, 4),RIGHT(A2,2),1)

This will actually return a date for Jun 1, 2003, which you can format for
"06/2003" with Format - Cells - Number - Custom:
mm/yyyy.

Or if you don't want a for-real Excel date, you can just convert the text
string:

=RIGHT(A2,2) & "/" & LEFT(A2,4)
 
Top