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.