Sorting ListView by Number

[spence74]

Does anyone have any information to get a listview to sort numerical data correctly?

For example, I have a listview with the following values:
35
50
10
117
425
425

When I sort by this column, I get:
10
117
35
425
425
50

I realize that this would be the correct sort order for text data... How can I get it to sort correctly for numeric data?

Thanks!

 

[Sheco]

Numbers will sort correctly if they have leading zeros.

So it could be like this:
010
035
050
117
425
425

 

[Sheco]

Hmmm, but that won't work too well on a mix of positive and negative numbers.