Quote:
Originally Posted by dan dungan
try placing the following formula in the "formula" section of the data
validation dialog box.
=AND(LEN(A1)=8,NOT(ISNUMBER(VALUE(RIGHT(A1,1)))))
|
Many thanks for you help. There is still a slight problem as that validation would permit a letter or other character in the first 7 digits and I only want numbers in the first 7 places.
regards
MJD