Hi gurus.

I am trying to sort out a validation rule which will allow users to enter certain values into column A. However, the difficult bit is that the values can be a set of numeric OR text strings. I'll elaborate:

The text entries that will be permitted are:

Faulty
Free
Reserved

The numeric strings permitted should be of the following formats only (here's the tricky one). The X's shown below are ofcourse representing any number from 0 to 9.

2xxxx
2004xxxx
2005xxxx
2007xxxx

I hope this will be enough for some1 to help out.

Really appreciate everyone's time!

thanks