sorting a text datafield

[yolip]

Hi, I want to sort a text datafield into numeric format.

e.g
original data
1
10
2
3
30
4

sorted data
1
2
3
4
10
20

anyone got idea with it? please help

thanks

[pnish]

Create a formula in your report that converts your text data to numbers, ie formula = Val(your text field here) and then set the report to sort by the formula instead of the text field.

[Hack]

You can also make each of your text numbers double digits and they will sort properly.

In other words:

01
02
03
04
05
06
07
08
09
10