convert date in Excel from 03021997 to dd-mmm-yyyy

[breddi76]

Dear all,


I have dates entered as eg: 3021997, 15122000..etc (i.e. day 03, 02 Month, Year 1997) I would like to know if there is any formula to convert to DD-MMM-YYYY. I tried every possible option such as copy n paste from notepad to excel and formatting cells, using text to columns option etc..


Could any one give any solution to this problem. I really appreciate your help.


Thanks in advance.

 

[Marc L]

Hi !     Cell formula to convert (7 or 8 figures) cell G2 :    

=DATE(RIGHT(G2,4),MID(G2,LEN(G2)-5,2),MID(G2,1,LEN(G2)-6))

          Enjoy !

 

[Debraj]

Hi Breddi,


Just little more in your enjoyment..

=DATEVALUE(TEXT(A1,"##-##-####"))

Regards,

Deb

 

[Marc L]

Hi Deb, I like your way !   Just have also to apply a date format to the cell …

 

[Debraj]

Glad that you like it..

And thanks for the supporting line..

Regards

Deb

 

[breddi76]

Hi Debraj and Marc,


I really appreciate you guys..


Thanks again fro your time and help.





Have a good day.