Converting date format in excel sheet [Solved/Closed]

Question

Converting date format in excel sheet [Solved/Closed]

Report

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?

Converting date format in excel sheet
How to convert date format in excel to dd/mm/yyyy - How-To - Excel
How to convert date format in excel ✓ - Forum - Excel
How to change date format in excel sheet - How-To - Excel
Unable to convert date format in excel ✓ - Forum - Excel
How to convert date from dash to slash format in excel ✓ - Forum - Office Software

1 reply

Ask a question

daywish · Answer 1 · 2009-02-10T04:25:44-0500

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.

Converting date format in excel sheet [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!