When sorting numbers in excell with letter in front and then zeros, I
don't get the expected results. The Macintosh OSX finder views the
numbers correctly, but I can't seem to get the same results in excel.
Can this even be done in excel?

Excell sort
CA0002
CA00020
CA0021
CA02
CA021
CA02C
CA2

Needs to be
CA0002
CA02
CA02C
CA2
CA00020
CA0021
CA021


--
darkjedi
------------------------------------------------------------------------
darkjedi's Profile: http://www.excelforum.com/member.php...o&userid=29153
View this thread: http://www.excelforum.com/showthread...hreadid=489794