Good morning!

I am having an issue where i have set a clumn's cells to have validation on them.

The validation allows a whole numer between 8000000000 and 9000000000.

The data is a TFN.

But i use a VB app to read the excel files via drag and drop. If the cells aren't all numeric then it ignores the ones that aren't.

So i put that validation in there to make sure people are entering them as 10 digit numbers without the ),(, or -.

What I have noticed is if folks copy from another workbook and paste into the excel, with ),(, and - the cell accepts it with no problems : S

Is there a way around the pasting?

Thanks in advance!