Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1558
Home > Forums > Others >

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 : 5324 | Status : [Member] | Replies : 1
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
Hi,
I need “yyyy/mm/dd” date format In Data validation in Excel 2010

Regards
Sekar.c

Reply | Reply with Attachment
Alert Moderator 

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

Latest Posts