Zip code error, Need help if zip starts with zero

[snuffnchess]

I have been using a "get distance" VBA to calculate the distance between two zip codes (can work with city names as well) that links to a google api.

I stumbled upon a calculation error yesterday that occurs when a zip code begins with a zero. The VBA is ignoring that 0 and just picks up the rest of the numbers. I think what I need to add is something like

If length of start does not = 5, then start needs to have however many zeros added in front of the number until length = 5

(attached file, see row 4, - link should be creatinghttps://maps.googleapis.com/maps/api...j8SzHMSMltzQC4, but instead is creating https://maps.googleapis.com/maps/api...j8SzHMSMltzQC4)

VBA is

Please Login or Register  to view this content.

So, what I am trying to figure out in the VBA is how to make it so that if "start" and/or "dest" begin with a zero, how to make it look at start and/or dest as "0"+start

Help!

[xladept]

I punched in the zips for Boston (00215) and Pasadena (91106 where I am) and got 3229 miles

[snuffnchess]

Sorry for this... I solved the problem... I am leaving the solution up in case anybody needs is. Question that I do have, though, is there a better way to do this???

Please Login or Register  to view this content.

[CK76]

You can simply use Format()
ex:
start = Format(start, "00000")