View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default sorting numbers with an irregular number of digits

If they are sorting that way then I think they are formatted as text. You
"can" use a helper column as Pete suggest, but you can also convert all your
cells to numbers. To do this simply copy a blank cell, select your range,
paste special selecting "add". This will convert all text that looks like a
number to a number. Your list should then sort how you want. It kind of
depends on your preference really... Hope this helps :)

"hearthd" wrote:

I am working on a database and am importing customer numbers that
initially started with 1 digit and now include 5 digit numbers. When
sorted, the numbers with fewer digits are mixed in with the larger
digit numbers. Is there a way to add zeroes to the smaller numbers so
they sort correctly?