<div>
I need to do the exact opposite and I'm stumped.<br />
<br />
I have a date string &quot;20091128&quot; &nbsp;that i need converted into &quot;MM/DD/YY&quot;<br />
<br />
In excel I can split the cell into three parts, but can't put it back together in the format i want.<br />
<br />
any help would be appreciated! &nbsp;Thanks!
</div>


I need to do the exact opposite and I'm stumped.

I have a date string "20091128"  that i need converted into "MM/DD/YY"

In excel I can split the cell into three parts, but can't put it back together in the format i want.

any help would be appreciated!  Thanks!

<div>
<div class="content wysiwyg-content">
How do I convert a date 03/07/1974 to a string in Excel 2007? I would like to keep the leading zero and just have 03071974 ?
</div>
</div>


How do I convert a date 03/07/1974 to a string in Excel 2007? I would like to keep the leading zero and just have 03071974 ?

Convert Date to String in Excel 2007

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.

Microsoft Office

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