I am having some issues with cell formatting getting all messed up when combining cells. I am combining two cells into one
with the below code:
Range("A10") = Range("AB450") & "
" & Range("AC450")
Cell AB are zip codes, and AC is a country. My problem is when I have a zip code that starts with zero, for example
AB450="07522" and AC450="USA", when they are combined it shows up as "7522 USA", I need it to
show "07522 USA".
I have cell AB450 formatted with NumberFormat = "00000", so when it is in
AB450 it shows up with the zero in front. I am not sure how to select the specific data that I am combining in order to
format it to keep the zero.
I am thinking I need something like the below code inserted, but I'm stuck.
Selection.NumberFormat = "00000"