change the date format on the other way round

[learning_grexcel]

we have list of dates like 01-04-2007(1-march-2007) (dd-mm-yyyy) and I want to make it now like this 04-01-2007 (4th January 2007) so I mean I want the middle digit should be first one, and the first one should be in the middle.

Can you please help with this?

 

[Aladin Akyurek]

we have list of dates like 01-04-2007(1-march-2007) (dd-mm-yyyy) and I want to make it now like this 04-01-2007 (4th January 2007) so I mean I want the middle digit should be first one, and the first one should be in the middle.

Can you please help with this?

=TEXT(A2,"mm-dd-yyyy")

would display the date in A2 as you want.