Change the date format in excel 2007 worksheet

Closed

amol - 29 Apr 2015 à 05:54
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Moderator Last seen 3 July 2015 - 29 Apr 2015 à 07:30

Hello,
i want to know that howcan i change the date format in
excel 2007 worksheet if i want it like :- yyyy/mm/dd

regards,
Amol.

1 response

Réponse 1 / 1

MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Moderator Last seen 3 July 2015 69
29 Apr 2015 à 07:30

Go to format cells, Custom, if the format is not in the list, simply write the format the way you want it.