View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Blake Blake is offline
external usenet poster
 
Posts: 11
Default Sorting addresses by the number

I am trying to sort a column of addresses based on the number of the address.
(from lowest number to highest).

But when I do it, all numbers starting with 1 come first- so 1000 High
Street is listed before 5 High Street. I have tried to research this and I
can't find much info... just that it might have to do with numbers being
stored as text. Ive tried changing it and it doesn't work. Help???