Validating a date

  • Thread starter Thread starter eli
  • Start date Start date
E

eli

Hello again,

I would like to know how can i validate a cell that i
want to make sure a date is entered. I know how to
validate the format, but i want excel to say: no can do
if the person enters text instead of a date ?
example:
This is ok
Date

1 Jun 03

This is not ok

Date

Hello

I would like Excel to say, validate: you can not
enter "hello" in the date column

Thanks
 
Data / Validation / Change 'Allow any value' to 'Date'

Date must be entered in a recognised date Format.
 
You can use Data/Validation, but you'll have to construct a "generic" error message such as "You
must enter a valid date in this column." You can't get the message to include the incorrect
entry the user made.
 
Back
Top