<div>
MMM-DD-YYYY format <b><i>=TEXT((LEFT(SUBSTITUTE(A1,<wbr />&quot;,&quot;,&quot;&quot;),4)<wbr />&amp;&quot;-&quot;&amp;MID(S<wbr />UBSTITUTE(<wbr />A1,&quot;,&quot;,&quot;&quot;)<wbr />,5,2)&amp;&quot;-&quot;&amp;<wbr />MID(SUBSTI<wbr />TUTE(A1,&quot;,<wbr />&quot;,&quot;&quot;),7,2)<wbr />)*1,&quot;MMM-D<wbr />D-YYYY&quot;)</i></b><br />
<br />
Thanks
</div>


MMM-DD-YYYY format =TEXT((LEFT(SUBSTITUTE(A1,",",""),4)&"-"&MID(SUBSTITUTE(A1,",",""),5,2)&"-"&MID(SUBSTITUTE(A1,",",""),7,2))*1,"MMM-DD-YYYY")

Thanks

<div>
Both solutions worked perfectly.. Thanks Greatly!!
</div>


Both solutions worked perfectly.. Thanks Greatly!!

<div>
<div class="content wysiwyg-content">
Deal Excel Gurus i need your help,<br />
I am exporting data out of SAP for their time stamp and it is in this format 20,140,227,000,702<br />
<br />
I read a blog or two and saw the following:<br />
<br />
2014 year<br />
02 Month<br />
27 Date<br />
<br />
00 hrs<br />
07Min<br />
02 Seconds<br />
<br />
I am not interested in the time portion, just want to extract the date in either one column with a single function Month/Day/Yr or Year/Month/Date either way is fine.<br />
<br />
<br />
Thanks for the help!!
</div>
</div>


Deal Excel Gurus i need your help,
I am exporting data out of SAP for their time stamp and it is in this format 20,140,227,000,702

I read a blog or two and saw the following:

2014 year
02 Month
27 Date

00 hrs
07Min
02 Seconds

I am not interested in the time portion, just want to extract the date in either one column with a single function Month/Day/Yr or Year/Month/Date either way is fine.


Thanks for the help!!

SAP - Excel date time stamp conversioN

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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