Problem Sorting by # in a portal

[snatkins]

I have a portal that has records shown in order of "edition #." From 1/25 (1 of 25) to 25/25. It is set to sort by the #: 1 first through 25. Unfortunately, when it sorts - it puts everything with a "1" first so it looks like this:

1

10

12

13

14

15

.....and then goes to 2, 21 - so obviously it is sorting by the first # - how do i fix this?

Help!

Thanks,

Sarah

[-Queue-]

Is Edition # defined as text or number? If number, it should sort correctly. If text, you will need to sort by a calculation field equal to

Right( "0" & EditionNumber; 2 )