sorting a text datafield

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

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.

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