I am preparing a huge mailing list for a mail merge. I’ve been instructed to sort by zip code. All of the mailing addresses are from the USA and Canada only. I removed the +4 digits for the US addresses, and put the Canadian zip codes in the cell with each city. There is a blank cell in the zip code column for each of the Canadian addresses. When I select it to sort by zip, this message comes up: “The following sort key may not sort as expected because it contains some numbers formatted as text. What would you like to do? 1) sort anything that looks like a number as a number? or 2) sort numbers and numbers stored as text separately. Can someone please help me to figure out what I’m doing wrong? I’m extremely frustrated at this point because I’ve tried several methods and it’s just not working. Thank you so much.