Convert date

Closed
suresh - Jun 26, 2012 at 10:36 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 28, 2012 at 09:29 AM
Hello,

Please how can I convert DDMMYY(200511) to DD-MM-YYYY(20-05-2011) in excel

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 28, 2012 at 09:29 AM
Hi Suresh,

Right-click the cell and select Cell properties. (or hit Ctrl+1).
On the numbers tab either select Date and find the right format or go to the bottom option and manually input you desired format.

Best regards,
Trowa
0