| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Sorting
I have a list of part numbers in a column which I need to sort
When I use the sort function in excel, it will sort them according to their number size, ie. 31, 41, 311, 411 I need them to read as 31, 311, 41, 411 How on earth do I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number Sorting
You need to make them text. If your #s are in A1:A100, enter this in B1:
=A1&"" and fill down, then sort on column B. HTH "Darren" wrote: I have a list of part numbers in a column which I need to sort When I use the sort function in excel, it will sort them according to their number size, ie. 31, 41, 311, 411 I need them to read as 31, 311, 41, 411 How on earth do I do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number Sorting
in B1, ebter =A1&"" and fill down. Then sort on col B
"Darren" wrote: I have a list of part numbers in a column which I need to sort When I use the sort function in excel, it will sort them according to their number size, ie. 31, 41, 311, 411 I need them to read as 31, 311, 41, 411 How on earth do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting number combinations | Excel Discussion (Misc queries) | |||
| VIN Number sorting | Excel Worksheet Functions | |||
| sorting same model number | Excel Discussion (Misc queries) | |||
| Sorting by Row Number? | Excel Worksheet Functions | |||
| Sorting by Number of Characters | Excel Discussion (Misc queries) | |||
Linear Mode
