T tina joshi New Member Aug 13, 2014 #1 I have text 20021023 which has to be converted to proper date format. What excel function can be used for this ?
I have text 20021023 which has to be converted to proper date format. What excel function can be used for this ?
pecoflyer Well-Known Member Aug 13, 2014 #2 Try Data- Text to columns - Next - Next - change date format to YMD - Finish
Deepak Excel Ninja Aug 13, 2014 #3 In a formula approach try this!!! =DATE(LEFT(A5,4),MID(A5,5,2),RIGHT(A5,2))
