date format excel

Problem 1: I have an Excel Cell which has the number format as dd.mm.yyyy.

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 'dd.mm.yyyy'?

problem2: When I set the date format in the cell to dd.mm.yyyy - 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.

Answers


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


I suppose you could define a custom format!!

I did try and it worked!! :)


Need Your Help

Is AlarmManager suitable for writing clock widget?

android alarmmanager clock

I want to write my own clock widget on Android. I am using my own icons to show the time (i.e., updating the ImageView(s) every second). I found a method using AlarmManager to handle the update and

Objective-C++ pre-compiled headers

c++ objective-c xcode macos objective-c++

I'm using a C++ library (it happens to be in an iPad application, but I'm not sure that should make any difference) and would really like to have the headers pre-compiled to speed up the builds, but