+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : sort smallest number to largest

  1. #1
    Forum Contributor
    Join Date
    10-13-2008
    Location
    wales (uk)
    Posts
    113

    sort smallest number to largest

    hello peeps

    I have a code on one of my sheets which automatically sorts all the cells after user input. can someone tell me how to modd it so it sorts the number from smallest to largest? at the mo I have number such as 10, 15 20, 215, 60, etc etc it is ordering 215 before 60 because of the first digit.

    here is the code

    Please Login or Register  to view this content.

    Any help would be most appreciated.

    Raj
    Last edited by NBVC; 12-06-2011 at 11:19 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    341

    Re: sort smallest number to largest

    Probably better asking in the VBA section, but have you considered that the numbers might not actually be read as numbers? That would be the only explanation I can think of.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1