Thanks a million...this refreshed my memory.

Also a colleague opened up my file in open office as was able to access the data validation for this cell. Unsure why excel keeps giving me the error "The selection contains more than on type of validation. Erase current setting and continue? [OK] [Cancel]".