I have a column which I have validated using the Data, Validation method.

I have used :

Please Login or Register  to view this content.
and dragged it down the entire column.

I need this code to be disregarded if the user enters a '-' at the end of the value in the cell...i.e. if the user enters 150 the code will still work and if there is a duplicate then the error message will appear. But if the user enters 150- then even if there is a duplicate the message will not apear.

I am completley stuck on this one... please help