Hippocode Posted March 22, 2012 Share Posted March 22, 2012 (edited) The Descending and Ascending Sort function in the worksheet are nice but don't work properly on numbers placed in a text field. A lot of PIOS use a number to trace them, ideal to list them in a worksheet. Sadly, that number is stored as a string and won't sort properly Sorting will give the following: 1 10 11 2 21 22 3 4 5 6 7 8 9 Is there any way to sort them the right way and not tread them as if they were strings ?? Edited March 22, 2012 by hippothamus Quote Link to comment
michaelk Posted March 22, 2012 Share Posted March 22, 2012 add the value function, =VALUE('xxxx'.'xxx') Value treats text as numbers. hth mk Quote Link to comment
Hippocode Posted March 22, 2012 Author Share Posted March 22, 2012 That seems to work, thanks. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.