I have a column of numbers but it is sorting as a dictionary sort (1, 11, 100, 2, etc). I don't recall this being a problem before but not seeing anything in the Help where I can tell it to sort numerically and not sure what could have changed. I see this behavior in 4.70 and 5.00 versions. Suggestions?

Jim

Most likely, the problem is in the type of your data. Generally this effect occurs if you store numbers as strings. Check them, and if it is the case, try to upload them into iGrid as real numbers (Integer, Long, etc).

If you wish to have your cell values as strings, there is an alternative which requires some coding. In this case, you can use custom sorting and compare pair values as numbers in the CustomSort event.

Thanks...not sure why it suddenly starting doing that as I am fairly sure it worked before. In any event, I added zero to each value as it loads and the problem has gone away. Thanks again.

Jim