I need “yyyy/mm/dd” date format In Data validation in Excel 2010

Posted by Sekar.C under Others on 4/4/2014 | Points: 10 | Views : 2628 | Status : [Member] | Replies : 1
Hi,
I need “yyyy/mm/dd” date format In Data validation in Excel 2010

Regards
Sekar.c



Responses

Posted by: Antonydurai on: 4/9/2014 [Member] Starter | Points: 25

Up
0
Down
Hi,

Select the cell and right click => Format Cell.

In number tab set following settings.
1. category as "Date"
2. locale as "English (Australia)"
3. Type as "2001/03/14"




Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response