Dave (and Chuck and Gary's Student),

I kept the original entry with the range in one field. I do have it
separate now as well. Obviously, I wasn't thinking when I entered them in
one.

I have kept the alpha characters out for now. That can be worked around.
I'm trying both of their solutions now. I was having trouble with Chuck's
option (user error) and I just made it happen! Yeah!!! You guys are soooo
wonderful! I still want to try the solution from Gary's Student. I love
learning new things.

A question though, the Conditional Format gives me the exact field formatted
how I want it... and then I scroll through the doc to find the one selected.
Is there a way to have the cursor move to that field? Sorry if I'm asking
too much. Just really excited to have made this progress. Thanks to all of
you!!!!

Penny

"Dave O" wrote:

Penny-
In retrospect it probably was a good idea to separate the beginning and
ending document numbers, since it will make the search and comparison
easier. For clients with only one document number, the beginning and
ending doc numbers will match.

The responses above from Chuck and Gary's Student will work where the
document numbers are purely numeric with no alpha characters. How much
trouble is it to keep the alphas separate from the numerics?