Numbers

  • Thread starter Thread starter caleb
  • Start date Start date
C

caleb

when i sort a collumn of numbers, par say
1,2,3,4,5,6,7,8,9,10,11,12,13,... and a sort it A->Z it
does it like
this...1,10,11,12...19,2,20,21...29,3,30,31... how do i
make it 1,2,3,4...9,10,11,12...19,20,21...????
 
caleb said:
when i sort a collumn of numbers, par say
1,2,3,4,5,6,7,8,9,10,11,12,13,... and a sort it A->Z it
does it like
this...1,10,11,12...19,2,20,21...29,3,30,31... how do i
make it 1,2,3,4...9,10,11,12...19,20,21...????
Click to expand...

That happens because you are sorting characters (Text) not numbers.

Changing the field type to a number type will take care of that.
However it will also eliminate or error out any records that have letters
(like A, B, C..) or eliminate any leading zeros like 0012.

I suggest you copy the table and make the changes to the copy first to
make sure it all goes smoothly.
 
Back
Top