locked
sort numbers RRS feed

  • Question

  • I have a list in sharepoint that I want to sort by number. For example the list have numers from 1 to 30 in mixed order. When I sort the numbers the come in this order: 1, 11, 12 and so on. I want the number to come in this order, 1,2,3 ....

    How can I do that?

    Friday, October 7, 2011 11:53 AM

Answers

  • Sounds to me as if you store these number in a text field rather than in a number field.

    Text fields are sorted literally. To sort by number you have to store the value in a number field.

     


    Stefan Goßner
    Senior Escalation Engineer - Microsoft CSS
    This post is provided "AS IS" with no warrenties and confers no rights.
    Friday, October 7, 2011 12:00 PM

All replies

  • Sounds to me as if you store these number in a text field rather than in a number field.

    Text fields are sorted literally. To sort by number you have to store the value in a number field.

     


    Stefan Goßner
    Senior Escalation Engineer - Microsoft CSS
    This post is provided "AS IS" with no warrenties and confers no rights.
    Friday, October 7, 2011 12:00 PM
  • Of course, thanks! :)

    /Jessica


    jesgre
    Friday, October 7, 2011 12:20 PM