Earl, see if this will do what you want,
http://www.contextures.com/xlDataVal07.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Earl" wrote in message
...
Has anyone come across this before?
I am listing a series of telephone numbers in an excell spreadsheet, and I
do not wish to duplicate any of the numbers already on my list, is there a
numbers prompt that someone knows about-they can kindly pass onto me as a
tip? (just like when using the letter or word prompts in an excell spread
sheet)

pls email: