Convert date format?

[excelbetter]

How do you convert this date format: [FONT=&quot]2017-03-18

To this: 03-18-2017

Any help is appreciated.[/FONT]<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}</style>

 

[sureshxcell]

Try

=TEXT(MID(TRIM(E6),1,10),"dd-mm-yyyy")+0

Right click > Format Cells > Custom > "select the TYPE box" > enter dd-mm-yyyy

 

[cooper645]

Hi,

Think you mean mm-dd-yyyy

correct, tired brain