Date Change to dd/mm/yyyy to dd/mm/yy [Closed]

ANDY - Nov 25, 2015 at 12:05 AM - Latest reply: kieferschild 2389 Posts Sunday October 5, 2008Registration dateModeratorStatus May 24, 2018 Last seen
- Nov 25, 2015 at 07:17 AM
Hello,
I Want to change date format dd/mm/yyyy to dd/mm/yy in MS Excel 2003
Please revert me urgently


See more 

1 reply

kieferschild 2389 Posts Sunday October 5, 2008Registration dateModeratorStatus May 24, 2018 Last seen - Nov 25, 2015 at 07:17 AM
-1
Thank you
Hello,

Right-click the cell and choose format cells.

Under category select "Date"

select the format you want.

you could also select "Custom" and type dd/mm/yy