Sort Number 1..n

Hello,

How to sort number 1…n, so that it looks like, 1,2,3,…n. In a column. In my application one of the view shows contract numbers, as C-1, C-2, etc. User wants to see those C-numbers like, C-1, C-2 …C-n, but currently it shows as C-1, C-10, C-100,C-2 etc… Any idea how to show like Ascending order?

Thanks

MS

Subject: Sort Number 1…n

To get around this issue what I’ve done is created a hidden first column that sorted, but only contains the extract numeric portion, converted to a number. The your text column can be unsorted because it follows the sorted column.

Collin

KC8TKA

Subject: RE: Sort Number 1…n

Thanks and It’s done. I appericiate your time.

MS