Convert to mm/dd/yy to dd/mm/yyy

Closed
Ravindra - Mar 23, 2015 at 12:46 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Mar 24, 2015 at 12:59 PM
Hello,

Pls help how to change mm/dd/yyy to dd/mm/yy in excel.

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Mar 24, 2015 at 12:59 PM
Hi Ravindra,

This can be done by formatting your cells.

Select your cells and go to cell properties (Ctrl + 1) > Numbers tab > Custom.
Then enter the following string:
dd/mm/yy

Best regards,
Trowa
0