Report

Converting date format in excel sheet [Solved/Closed]

Ask a question suni - Last answered on Feb 10, 2009 at 04:25 AM by daywish
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?
See more 
Helpful
+1
plus moins
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.
Was this answer helpful?  

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!