date conversion

[ljw]

How can I convert this date expression "19410712" to "January 12, 1941" or "1/12/1941"?

[wei82]

How can I convert this date expression "19410712" to "January 12, 1941" or "1/12/1941"?

I think u can go to data -> text to columns -> choose fixed width and separate the text into 1941,07,12...after that use concatenate function(e.g. =concatenate(A3,"/",A2,"/",A1).)

[wei82]

or u can try tis out
=CONCATENATE(MID(A1,7,2),"/",MID(A1,5,2),"/",MID(A1,1,4))
Juz put your text in A1...

[oldchippy]

How can I convert this date expression "19410712" to "January 12, 1941" or "1/12/1941"?

I can see where the 1941 comes from, but not sure how you get January out of either 07 or 12, but try these

=MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4) this will give a text result of 07/12/1941

=1*(RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)) custom format to "mmmm dd, yyyy" without the " "

=TEXT(A1,"0000-00-00")*1 custom format to "mm/dd/yyyy" without the " "


Re-edited

[ljw]

I can see where the 1941 comes from, but not sure how you get January out of either 07 or 12, but try these

=MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4) this will give a text result of 07/12/1941

=1*(RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)) custom format to "mmmm dd, yyyy" without the " "

=TEXT(A1,"0000-00-00")*1 custom format to "mm/dd/yyyy" without the " "


Re-edited

***
I apologize for not reading the date correctly. Late nite here. Thanks for your help.

I think u can go to data -> text to columns -> choose fixed width and separate the text into 1941,07,12...after that use concatenate function(e.g. =concatenate(A3,"/",A2,"/",A1).)

***
***
Thanks for the simple fix. I apologize for misreading the date.

Thank you all for the help. Somewhat new at this!

[oldchippy]

Glad to help - thanks for the feedback

[daddylonglegs]

You can actually convert such dates in situ, with Text to columns without having to split and concatenate....

Select column of dates
Data > Text to columns > Next > Next
At step 3 choose "date" under "column data format" and YMD option
Finish

[ljw]

You can actually convert such dates in situ, with Text to columns without having to split and concatenate....

Select column of dates
Data > Text to columns > Next > Next
At step 3 choose "date" under "column data format" and YMD option
Finish

***

So simple! Learned much from this community. Hope I can reciprocate. Thank you all from the windy isle of Avalon in southern NJ.