prevent duplicate numbers in column

[CG]

Is there a way to prevent duplicate numbers in a column in excel?

Thanks

 

[JE McGimpsey]

See

http://cpearson.com/excel/NoDupEntry.htm

 

[Frank Kabel]

Hi
see:
http://cpearson.com/excel/NoDupEntry.htm