Hello

I am trying to use the contents of 2 cells to produce I.D. numbers the first
cell contains 2 or 3 letters the second cell is a counter which advances
each time a macro is run.
I have no problem joining the 2 together by using =A1&A2 (or even
=A1&""&A2).
The problem is I am compiling a database of several hundred of these records
and eventually I sort the records and the results are not in the correct
order.
If these had just been numbers I would use 0001, 00002 etc by formatting but
this is not working when the 2 cells are joined.
Even though A1 entry is CH and A2 is formatted and reads 0001 the result is
CH1 - needless to say sort would put CH11 before CH9
I tried putting some zeros in by =A1&"000"&A2 but this did not work as it
was messed up as soon as A2 contained double figures!

Can anyone suggest how I can get the results I want?

Kenny
Win2000 and Excel97 (forced upon me-not my choice!!!)