Data Validation Query
Posted by JAF on June 04, 2001 4:03 AM
Hi - I'm not sure if this is possible, but here we go...
I've been using the Data Validation settings to ensure that a specified column can only contain date values greater than or equal to 01/01/2001.
I now need to allow users to input either a valid date OR the text "N/A" - obviously, using the Data Validation set to "Date" prevents me from inputting "N/A" into the column.
Is there any way to force dates in the column to be valid dates (i.e. to stop careless people from inputting something like 31st April 2001), but to still allow the use of N/A as well?