Is there a way to format a column so that no number ever repeats? So if a
3rd party is entering an ID number, and it already exists, it won't let
them...

Check out this web page of Chip Pearson:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Chris Shearman" <(E-Mail Removed)> wrote in message
news:ODYdn$C$(E-Mail Removed)...
> Is there a way to format a column so that no number ever repeats? So if a
> 3rd party is entering an ID number, and it already exists, it won't let
> them...
>