Sorting Numbers (Reopened)

[zburns]

Still having problems sorting numbers with text data type.
I have used Sort: Format([Field],"0000") but it drops numbers to right of decimal and the decimal.
How do I sort a text field such as:
1.0
2.2
2.3
13.9

Instead of:


0001
0002
0002
0013

Thanks

[ranman256]

convert them to numeric to sort
show the string, but sort on the converted number...

[NumStr], CDbl([NumStr])

[ssanfu]

Have you tried Format([Field],"0000.0")?

[orange]

Review the CDec() function

[zburns]

Thanks - That will work

[zburns]

Forgot to mention ssanfu