Adding a HYPHEN to a 9 digit zip code column
2 problems with that...
1. If the postal code is only 5 digits then format returns
00001-2345
You are better off with this custom format
[99999]0000-0000; 00000
2. Formats will not work in this instance. The OP is doing a mail merge and
formats are not carried forward as part of the merge.
--
HTH...
Jim Thomlinson
"James" wrote:
One way you can do it is to use the Format Cells and under the category
select "Custom" in the box enter this 00000-0000. That will seperate the the
last 4 digits with a dash.
"William" wrote:
I have a column with nine-digit zip codes, but there is no hyphen separating
the final zip four numbers. I need to use this column in a mail merge, but
don't want to go in and manually add all the hypens. There must be a way to
do this (Find/Replace using placeholders?) but I can't quite come up with it.
Ideas?
Thanks,
--
William
|