AnsweredAssumed Answered

Sorting numbers in logical order?

Question asked by Werner on Mar 3, 2014
Latest reply on Mar 4, 2014 by TSGal

Title

Sorting numbers in logical order?

Post

     how can I get FM to sort (e.g.) the numbers 1199 - 12 - 120 - 1200 in the wanted order 12 - 120 - 1199 - 1200??? There are of course many more numbers in between, in total it is a collection of 4600 posts (litt ref cards), each card has six fields, of which one is a consecutive number given when the cards were written....  

     The set has been imported from Excel, but if not possible without adding one or two zeros before them all, I have to remain in Excel.

Outcomes