Originally Posted by Perpmotion

Thank you, Spencer...I did think of that (and it does work), but I was trying to make this little snippet as idiot proof as possible, as the report that the 3-6 digits is gleaned from does not print the leading zeros. In that way, the user will only have to enter the numbers printed (sans the zeros) to get the result (I know, you would think grown people who work here would know that a code used in our process was 6 digits long, but alas). I can send you the workbook, if you have the time, and send me another contact point (I tried uploading the project to the forum, and it wouldn't accept anything but a .jpg/picture). Thanks again for your help.