Previous Topic Next Topic

Converting date format in excel sheet

Solved/Closed
suni - Feb 10, 2009 at 04:14 AM
daywish
Posts
29
Registration date
Tuesday December 30, 2008
Status
Member
Last seen
July 21, 2009
 - Feb 10, 2009 at 04:25 AM
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

Answer 1 / 1
daywish
Posts
29
Registration date
Tuesday December 30, 2008
Status
Member
Last seen
July 21, 2009
 17
Feb 10, 2009 at 04:25 AM
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.
-1