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

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

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

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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