<div>
Are they always in this format?<br />

</div>


<div>
I am sure there is a way to do this with with a macro or VBA script, but here is a workaround.<br />
<br />
A1: 1072210<br />
B1: =LEFT(RIGHT(A1,6),2)<br />
C1: =LEFT(RIGHT(A1,4),2)<br />
D1: =LEFT(RIGHT(A1,2),2)<br />
E1: =D1&amp;&quot;/&quot;&amp;C1&amp;&quot;/&quot;&amp;B1<br />
<br />
You could hide columns B, C, and D if you don't want to see them.
</div>


I am sure there is a way to do this with with a macro or VBA script, but here is a workaround.

A1: 1072210
B1: =LEFT(RIGHT(A1,6),2)
C1: =LEFT(RIGHT(A1,4),2)
D1: =LEFT(RIGHT(A1,2),2)
E1: =D1&"/"&C1&"/"&B1

You could hide columns B, C, and D if you don't want to see them.

<div>
Assuming that 0990922 should be converted into September 22, 1999 and 1071022 into October 22, 2007, you might try:<br />
=DATE(LEFT(A1,3)+1900,MID(<wbr />A1,4,2),RI<wbr />GHT(A1,2))<wbr /><br />
Format the results of the formula as a date.<br />
<br />
Brad
</div>


Assuming that 0990922 should be converted into September 22, 1999 and 1071022 into October 22, 2007, you might try:
=DATE(LEFT(A1,3)+1900,MID(A1,4,2),RIGHT(A1,2))
Format the results of the formula as a date.

Brad

<div>
Brad<br />
What can I say...You did it once again!<br />
Would not have even thought of +1900.<br />
Thank You :)<br />

</div>


Brad
What can I say...You did it once again!
Would not have even thought of +1900.
Thank You :)


<div>
<div class="content wysiwyg-content">
I need help in converting this number to a date &nbsp; &nbsp;1070922 &nbsp; &nbsp;to &nbsp;9/22/07 &nbsp; &nbsp; it is a number and not text. <br />
A formula or macro would work. It is in column K.
</div>
</div>


I need help in converting this number to a date    1070922    to  9/22/07     it is a number and not text. 
A formula or macro would work. It is in column K.

Convert number to date

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.