My product codes are a year followed by two or three letters followed by a number. For example 87LC10 tells me that this product is the 10th product recorded at a specific 1987 event. (87LC is the code for the event). However, when I put all these product codes in, ZC sorts them so that 87LC1 is followed by 87LC10 rather than 87LC2. I would like 87LC10 to follow 87LC9, not following 87LC1 as it does now.
Is there some setting I can change so that ZC will sort these product codes the way I want?

Colin