Parse text file or xml into listboxes

[Doogle]

Also, having some trouble with your code for sorting. Some of the fields in distance will not be numbers. but the word "Unknown"

How about instead of 'Unknown' you put in a value of minus one ? You might have to adjust the leading zero bit to account for the '-' sign (they'd then sort to the top), alternatively you could put a value greater than the radius of the earth (they'd sort to the bottom), then after the sort you could change them to 'Unknown' if required

[ice_531]

Unknown worked fine with code MarkT posted above.

Also resolved the zip code dilemma.

Forgot about the excel .TEXT property.

I guess I should have read the help in excel sooner and figured that out.

Have the leading 0 issue fixed with that now