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? |
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? |
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? |
All times are GMT +1. The time now is 09:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com