AnsweredAssumed Answered

How to Sort Correctly Using a Simple Dashed Format, ie 1-1

Question asked by janman on Jan 21, 2011
Latest reply on Jan 24, 2011 by ninja

Title

How to Sort Correctly Using a Simple Dashed Format, ie 1-1

Post

Hello experts ... I'm not a pro but I have FM Pro Advanced v10.  Just trying to do a simple sort.  I've searched through all the forums and tried a few things but still doesn't work properly.  I have item numbers that go like this ... 1-1, 1-2, 1-3 ... 1-10, 1-11 ... 2-1, 2-2, 2-3, etc.  Very simple.  When I run a Sort it turns out like 1-1, 1-10, 1-11, 1-2, etc.  I have the numbers in a TEXT field but have also tried a NUMBER setting.  I have also tried removing the dash and using a period.  Same thing.  Seems goofy that this program can't count from one to ten and put things in the right order.  Hope someone has a simple solution / explanation.  Many, many thanks!

Outcomes