AnsweredAssumed Answered

Sorting numbers in logical order?

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


Sorting numbers in logical order?


     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.