I am working on a mail merge using an excel table and word (both XP) and have encountered a problem that I hope is easy to solve.
The converter between excel and word does an interesting thing to zip codes, if the zip code starts with zero or is a zip + four it comes up in word as "0". The microsoft knowledge base says it knows this to be a problem and the workaround is to put ' before the zip so that the converter treats this column as text. Here's the question, is there a formula that would add ' to the beginning of all the zip codes?
The converter between excel and word does an interesting thing to zip codes, if the zip code starts with zero or is a zip + four it comes up in word as "0". The microsoft knowledge base says it knows this to be a problem and the workaround is to put ' before the zip so that the converter treats this column as text. Here's the question, is there a formula that would add ' to the beginning of all the zip codes?