prevent duplicate entry for range of numbers 00001 to 99999 in ex.
 

is there a way to prevent a duplicate entry for a range of numbers between
00001 and 99999 in column?

Thanks ... TK

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
.

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
.

TK

Chip Pearson shows you how using Data Validation

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


Gord Dibben Excel MVP

On Fri, 4 Mar 2005 13:07:05 -0800, "TK" wrote:

is there a way to prevent a duplicate entry for a range of numbers between
00001 and 99999 in column?

Thanks ... TK

thanks for the link ... just what I needed ... TK

"Gord Dibben" wrote:

TK

Chip Pearson shows you how using Data Validation

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


Gord Dibben Excel MVP

On Fri, 4 Mar 2005 13:07:05 -0800, "TK" wrote:

is there a way to prevent a duplicate entry for a range of numbers between
00001 and 99999 in column?

Thanks ... TK