close

How do I convert this date quot;060426quot; to quot;4/26/2006quot;


Assuming the 060426 is in cell A1, type the following formula:-

=DATE(20amp;LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))

Then format this cell with a format M/DD/YYYY--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: www.excelforum.com/member.php...oamp;userid=17084
View this thread: www.excelforum.com/showthread...hreadid=535499

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄