Hi Allison and anyone else who might find this useful Yes, Jae has the answer - I had problems with this too. Also, don't use Excel to create the file because it removes the leading zeroes. This I found out the hard way!
Lucy On Friday, March 10, 2017 at 11:50:07 AM UTC+2, Allison Lee wrote: > > Oh yes but of course, 01, 02, etc. should solve it fine. Very simple :) > Thanks Jae! > > Allison > > On Friday, March 10, 2017 at 5:36:07 PM UTC+8, Jae Hun Lee wrote: >> >> Hi, >> >> I guess the comparison is done as if they are strings. 10 is bigger than >> 1 because first character is identical and 10 has second character where 1 >> doesn't. 2 is bigger than 13 because 13 starts with 1. Therefore, I would >> suggest to change the order value to 2 digits: 10-23 or 01-13 and test with >> the system. I hope my analysis is okay. >> >> Best regards, >> Jae >> >> >> On Friday, March 10, 2017 at 1:52:48 PM UTC+5:45, Allison Lee wrote: >>> >>> Hello all, >>> >>> The sort order value numbering system gets skewed once in double digits, >>> displaying higher values before lower values. For example, if I have 13 >>> items, it orders them: 1, 10, 11, 12, 13, 2, 3, 4, 5, 6, 7, 8, 9. Anyone >>> have a simple solution for this? The simplest I can think of is to just >>> use the alphabet instead of numbers... >>> >>> thanks! >>> Allison >>> >> -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
