| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom sorting with Letters and Zeros
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's Profile: http://www.excelforum.com/member.php...o&userid=29153 View this thread: http://www.excelforum.com/showthread...hreadid=536350 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Letters and 000s in front of actual number not sorting correctly | Excel Discussion (Misc queries) | |||
| Need help with TRIM function | Excel Worksheet Functions | |||
| Leading Zeros with a twist. | Excel Discussion (Misc queries) | |||
Threaded Mode
