Disallowing duplication of nmbers in a column

[Barb1]

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 here:
http://www.cpearson.com/excel/NoDupEntry.htm

--
Andy.


"Barb1" <Barb1@discussions.microsoft.com> wrote in message
news:E3631DD3-724E-4C0D-956B-4201876A9A4A@microsoft.com...
> 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.