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

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
0
Delwyn (1)
6/15/2005 1:53:03 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
461 Views

Similar Articles

[PageSpeed] 48

=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)



-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Delwyn" <Delwyn@discussions.microsoft.com> wrote in message 
news:4617851F-2781-4C3F-A3EA-FCF09F4AF11B@microsoft.com...
>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 


0
nothanks4548 (968)
6/15/2005 2:24:18 AM
Reply:

Similar Artilces:

How to change date as general "200306" to date "06/2003"
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 =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) -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------...