Date Change to dd/mm/yyyy to dd/mm/yy

Closed
ANDY - Nov 25, 2015 at 12:05 AM
 Blocked Profile - 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


1 response

Blocked Profile
Nov 25, 2015 at 07:17 AM
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
-1