Excel date masks

[Duncan Findlay]

Hi:

In MS Access there are masks available to restrict input info. Are there
such masks available in MS Excel? I specifically am looking for something
similar to MS Access' InputMasks fo use in MS Excel. My purpose is to
restrict the nature of input into a column reserved for dates only so that
the dates can be used as an acceptable "integer" to make comparisons with
dates in other cells.

Any suggestions?

Duncan

 

[Tom Ogilvy]

Look in Data=>Validation.

 

[Duncan Findlay]

Thanks, Tom:

That can work, but not quite in the same way as a "Mask" as in MS Access.In
the absence of any other method, I will use your suggestion.

Duncan