Sorting data in Excel

  • Thread starter Thread starter giangi
  • Start date Start date
G

giangi

Can anybody help me sort code? I have a list of product-code tha
contains zeros significant, and different lenght.
I am trying to sort them, but I obtained wrong results.

Example (data to order):

86010098
97800138
170098900
0016816
0016840
00337
00340
019615

Sorting them, nothing occurs.

Naturally, code with zeros has text format and others codes hav
numeric format.


Best regards.
Giangi

(I beg your pardon for my bad english
 
Hi,

If I select all fields containing your numbers, choose Data - Sort, and
then sort by the column containg the numbers, I am being asked wether I
want to sort anything that looks like a number, as a number, or sort
numbers and numbers stored as text seperately. Then I click OK, and it
works.

If I choose to sort numbers and numbers stored as text seperately, and
sort ascending, the numbers appear on top (sorted), and then the numbers
stored as text (sorted as well).

George
 
You need to either change everything to numeric format or make another
column equal to the first and format/sort that one.
 
Back
Top