Thread: prevent duplicate entry for range of numbers 00001 to 99999 in ex.
View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default
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

Reply With QuoteReply With Quote