How to Sort Correctly Using a Simple Dashed Format, ie 1-1
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!