Converting date format in excel sheet [Solved/Closed]

Report
-
Posts
29
Registration date
Tuesday December 30, 2008
Status
Member
Last seen
July 21, 2009
-
Hello,
I have a cell which contains date in the format dd/mm/yyyy, but i need to convert to mm/dd/yyyy in excel how can i do this?

1 reply

Posts
29
Registration date
Tuesday December 30, 2008
Status
Member
Last seen
July 21, 2009
17
dd/mm/yyyy is the standard format when using Excel in an english version, as for mm/dd/yyyy it is the standard format when using Excel in a French version, the simolest solution is erhaps to switch language.