<div>
I tried this format|cells|custom|mm/dd/<wbr />yyyy<br />
my 740108 and changed it to 5/6/3926. &nbsp;So this did not work for me. &nbsp; &nbsp; <br />
<br />

</div>


I tried this format|cells|custom|mm/dd/yyyy
my 740108 and changed it to 5/6/3926.  So this did not work for me.    



<div>
After playing around a little I was able to get this to work, Thanks.
</div>


After playing around a little I was able to get this to work, Thanks.

<div>
akeyes, iaminit second procedure most probably will fix it.
</div>


akeyes, iaminit second procedure most probably will fix it.

<div>
<div class="content wysiwyg-content">
I have some files sent to me that have the dates as YYMMDD and I would like a Macro that will change the date to MM/DD/YYYY can any one help me?
</div>
</div>


I have some files sent to me that have the dates as YYMMDD and I would like a Macro that will change the date to MM/DD/YYYY can any one help me?

Changing Date format in Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.