- ZIP code to text?
This is a multi-part message in MIME format. --=_NextPart_000_0018_01C3B927.B851FD70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need to convert ZIP code to text, keeping the leading zeros in the = text. Formatting a cell as ZIP CODE shows the lea...
- zip code to city, state function
Is anyone aware of a function that will read a zip code and result in a city and state? Example: IF(B25=53520,"Brodhead, WI",IF(B25=53521,"Katmando, WI",...... Any thoughts? I would type it up, but there are over 19,999 variations that I am considering for the 50000-69999 area codes that I think...
- zip code redux
This post pertains to formatting difficutlies when importing the zip field from an Excel spreadsheet that's using the zip format. Dave Peterson wrote: >After you select your Excel file as a data source, you should see a >'Confirm Data Source' dialog box. From that list, choo...
- Zip Code question for clarity
Hi, I was reading the newsgroup for some help on the leading zero problem with zip codes in mailmerge. What worked for me is that I re-typed everything formatted as text, not just "changing" the format from zip code to text in place. All those threads about copying the table into word confused m...
- Zip Code Macro
Again, thanks for all your help so far... And thanks in advance for this one. I have zip codes in Column I I have the Country Code (CA for Canada, GB for England and such, and US for ...) in Column H As you know some zip codes for the US can have a 5 or 9-digit format 90210 and 90210-1111 (for e...
- Zip code loses leading zero Mail Merge from Excel to Word Labels
Even though formatted as zip codes, I cannot get the leading zero to show in my zip codes when using Word mail merge to create address labels. Example: 04103 shows up on the label as 4103...