Hi,
look into CPearson web

http://www.cpearson.com/excel/NoDupEntry.aspx

if this helps please click yes, thanks

"BABYPINK" wrote:

Hi

I need to enter unique numbers (Manually) into a column

I just want to make sure there are no duplicates, the format is

SA123456
SA365489
SA222222

Hopefully if I do enter a duplicate the column will not let me

Thanks