Disallowing duplication of nmbers in a column
 

Is Excel capable of disallowing the same numbers in a column? I have a
column in a sheet that invoice numbers are entered into. I would like that
column to alert or something if duplicate numbers are typed in.

Hi

Have a look he
http://www.cpearson.com/excel/NoDupEntry.htm

--
Andy.


"Barb1" wrote in message
...
Is Excel capable of disallowing the same numbers in a column? I have a
column in a sheet that invoice numbers are entered into. I would like
that
column to alert or something if duplicate numbers are typed in.