Validating dates in excel Hot and spicy sexy bangalore online girls

01-Nov-2016 01:38

There are two other tabs on the Data Validation Menu: Input Message and Error Alert.

Using Data Validation you can create lists of items for the user to select from.

One of the great features that MS Excel has is the capability to restrict (validate) the input into certain cells.

The name of this feature in MS Excel is Data Validation.

The travel department of a major company asked its travel agents to track flights using dates, route codes (e.g., DEN-LAX-DEN) and destination city.

Travel agents found creative ways to make the analysis difficult: incorrect dates, swapping routes with destinations, misspelling destinations, leaving the hyphen out of the route.

Using Data Validation you can create lists of items for the user to select from.One of the great features that MS Excel has is the capability to restrict (validate) the input into certain cells.The name of this feature in MS Excel is Data Validation.The travel department of a major company asked its travel agents to track flights using dates, route codes (e.g., DEN-LAX-DEN) and destination city.Travel agents found creative ways to make the analysis difficult: incorrect dates, swapping routes with destinations, misspelling destinations, leaving the hyphen out of the route.However it is possible to create your own messages.