Afternoon All,

I have added validation in cell C34 to only accept a number between 0 - 10000. I now have a new requirement where cell C34 should be able to accept an number first, then a potential letter. For example 21D. the number part of the validation could be resticted to four digits, and only one letter will be required.

Any help would be much appricated.

Regards,

Matt