Bad sorting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a table of data. The first column is a series of numbers from
1-500 with a few numbers missing. When I sort this data ascending, it
sorts them as 1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109,
11, 110 etc. Of course what I want is 1, 2, 3, 4, etc.
What is Going on? I selected the column, went to Format>Cells>Number. I
selected "Number" with 0 decimal places.

How is this happening?

Scott

.

Relevant Pages

  • Re: Sorting again
    ... being a real programer I may be missing something. ... Sort the first column and if more then one like item sub sort the next ...
    (comp.lang.basic.visual.misc)
  • RE: Report in Certain Order
    ... Thanks again OssieMac for your patience, ... Drag the field into the first column of the matrix. ... DO NOT set the sort for this column. ... Close the close X to close the query builder and select save at the prompt. ...
    (microsoft.public.access.gettingstarted)
  • Re: Bad sorting
    ... When I sort this data ascending, ... Enter a one in any spare cell. ... I don't know if you want the missing numbers to be filled in or not. ...
    (microsoft.public.mac.office.excel)
  • RE: Report in Certain Order
    ... first column and the primary and secondary sorts in the correct order from ... Drag the field into the first column of the matrix. ... DO NOT set the sort for this column. ... Close the close X to close the query builder and select save at the prompt. ...
    (microsoft.public.access.gettingstarted)
  • RE: Combo box list help
    ... "Anyone who says he can see through women is missing a lot." ... Groucho Marx ... The first column is the issuerID and the second is the ... I'm not opposed to writing VBA for this, but am at a loss as how ...
    (microsoft.public.excel.misc)