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
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
-------------------------------------------
"Delwyn" <[email protected]> wrote in message
news:[email protected]...
>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks