The program I am writing now requires me to find a matching four
digits number to a alphbetical-numerical serial number that is provided
which inlude the number (and the entire number). E.g., Z0000, WPS0153,
QQ2346 and so on and so forth, so that 0000 is contained in Z0000 would
return true, and 0153 = WQS0053 would give false. Hopefully I am clear
enough here. :)
Now is the problem. I tried to make the Excel spreadsheet to take in
4 digits integers by specify the format to "0000". However, the value
shown in the formula bar, for 0000, is still 0, and hence, it would
return true for anything that contains the single digit 0, i.e., it
would return true for Z001 because it contains a 0 and return true to
Z0153 also because it contains a 0! That is far from what I want to do.
So I am wondering whether someone could come out with an VBA sub to
make my intended comparison work.