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

[TK]

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

Thanks ... TK

[Jason Morin]

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
>.
>

[Peo Sjoblom]

Or use this technique since I doubt it will prevent duplicates

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


--

Regards,

Peo Sjoblom



"Jason Morin" <[email protected]> wrote in message
news:[email protected]...
> 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
> >.
> >

[Gord Dibben]

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" <[email protected]> wrote:

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

[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" <[email protected]> wrote:
>
> >is there a way to prevent a duplicate entry for a range of numbers between
> >00001 and 99999 in column?
> >
> >Thanks ... TK
>
>