Validating date entry in cells
 

I have a column set to date format. The cells seem to accept invalid date
formats such as '01/01//2009'. The data is not converted to a date value.
Other date entries are modified. For example if you enter 01/02, Excel will
convert that to 1/1/2009.

What's a method to reject invalid dates such as above or 02/30/2009.

Validating date entry in cells
 

Have you tried using data validation and requiring dates to be entered?
--
HTH,

Barb Reinhardt



"DocBrown" wrote:

I have a column set to date format. The cells seem to accept invalid date
formats such as '01/01//2009'. The data is not converted to a date value.
Other date entries are modified. For example if you enter 01/02, Excel will
convert that to 1/1/2009.

What's a method to reject invalid dates such as above or 02/30/2009.

Validating date entry in cells
 

Use Data Validation. Select the column with the date format, then select Data
Validation (in XL2007, Data Validation is on the Data ribbon). Set the
validation to allow "Date" between 1/1/1930 and 12/31/9999 (or whatever date
range you want). This will reject any entry Excel can't recognize as a valid
date.

Hope this helps,

Hutch

"DocBrown" wrote:

I have a column set to date format. The cells seem to accept invalid date
formats such as '01/01//2009'. The data is not converted to a date value.
Other date entries are modified. For example if you enter 01/02, Excel will
convert that to 1/1/2009.

What's a method to reject invalid dates such as above or 02/30/2009.

Validating date entry in cells
 

Thanks for the quick answer. I was hoping I wouldn't have to select a date
range, but oh well.

John S.

"Tom Hutchins" wrote:

Use Data Validation. Select the column with the date format, then select Data
Validation (in XL2007, Data Validation is on the Data ribbon). Set the
validation to allow "Date" between 1/1/1930 and 12/31/9999 (or whatever date
range you want). This will reject any entry Excel can't recognize as a valid
date.

Hope this helps,

Hutch

"DocBrown" wrote:

I have a column set to date format. The cells seem to accept invalid date
formats such as '01/01//2009'. The data is not converted to a date value.
Other date entries are modified. For example if you enter 01/02, Excel will
convert that to 1/1/2009.

What's a method to reject invalid dates such as above or 02/30/2009.