Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Problem 1: I have an Excel Cell which has the number format as

I need to add limits to that particular cell, using Date criteria in Data Validation. In the data validation I set the start date to be higher that 01-01-2012.

But, if I enter the date '01.02.2012' in the cell I get an error message. "You have type an invalid value".

How can I changes the date format in data validation to accept StartDate wiht the format ''?

problem2: When I set the date format in the cell to - it will convert all dates to this format except if i type eg. 2012.02.01 - it will still be displayed in this format!

Any help will be appreciated.

Note: This is not a programming question.

share|improve this question

migrated from Jul 16 '12 at 1:53

This question came from our site for professional and enthusiast programmers.

Formatting normally only dictates how dates are displayed, not how your input is interpreted

Regional settings will determine how input is interpreted, what region are you in?

Presumably neither 01.02.2012 or 2012.02.01 are recognised as valid dates (at input). Try input as 01/02/2012 or 2012-02-01, you can still format the dates any way you want

share|improve this answer

I suppose you could define a custom format!!

I did try and it worked!! :)

share|improve this answer

You must log in to answer this question.