Or use this technique since I doubt it will prevent duplicates
http://www.cpearson.com/excel/NoDupEntry.htm
--
Regards,
Peo Sjoblom
"Jason Morin" wrote in message
...
Although it has its limitations, Validation is one way:
1. Select the range.
2. Go to Data Validation.
3. Under "Allow" select "Whole Number".
4. Fill in the "Min" with 0 and "Max" with 99999.
HTH
Jason
Atlanta, GA
-----Original Message-----
is there a way to prevent a duplicate entry for a range
of numbers between
00001 and 99999 in column?
Thanks ... TK
.