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???
|