Sorting Data Not Work

[muhammad susanto]

hello all..

i try to sort data asc to desc but not working , how to fixed it..

<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>sorted data</th></tr></thead><tbody>
<tr><td>5020103001-1</td></tr>
<tr><td>5020103001-10</td></tr>
<tr><td>5020103001-2</td></tr>
</tbody></table>


please, somebody help me...
thanks advance..

sst.<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

 

[Yongle]

The problem you have is that your data is being sorted like text because it is text

One way:

With your data in cells A1 to A3
Formula in B1 copied down
=LEFT(A1,FIND("-",A1)-1)
Formula in C1 copied down
=VALUE(MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1)))

Now sort
level 1 column B
level 2 column C

 

[Yongle]

Another way is to convert your data

with your data in cells A1 to A3

Formula in B1 copied down
=LEFT(A1,FIND("-",A1))&TEXT(MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1)),"000")

 

[sandy666]

with your example: A1:A3
in B1: =BASE(MID(A1,SEARCH("-",A1)+1,99),10,3) and drag down
select columns A and B with data
sort column B by A-Z

5020103001-1	001	B1: =BASE(MID(A1,SEARCH("-",A1)+1,99),10,3)
5020103001-2	002
5020103001-10	010