sorting numbers

[darkjedi]

Hi were have problems in sorting out our inventory item numbers. We have
over 15,000 item numbers that can't be changed or zeros deleted. The
problem is when there are zeros in the item number.

Excell sort
CA0002
CA00020
CA0021
CA02
CA021
CA02C

Needs to be
CA0002
CA02
CA02C
CA00020
CA0021
CA021

Thanks
Darkjedi

 

[darkjedi]

Since I didn't receive any replys, does this mean it can't be done or
it's just too dumb of question to get a reply.

darkjedi

 

[Niek Otten]

Problem is you chose a rather general title which had been used before. Many
Newsreader programs will stuff it under someone else's problem with the same
description. Since that had been answered already, nobody pays attention
anymore.
Repost with a somewhat more distiguingishable title.