M
MLD
A user had a weird issue the other day. She received an Excel table full of
names and addresses. Not so weird. But the person who generated it did not
use a consistent format in the Zip Code field, so the zips beginning with
zero, were all Smart Tagged as "this cell is formatted as text or has an
apostrophe in it'. And they did - in a mixed manner. When my user tried to
make mailing labels, those beginning with zero only populated the label zip
field with a '0'. I tried everything, clearing the formats of the column,
resetting, copying and pasting as plain text, using the Special Format -
Zip Code setting, using Text format on all - nothing worked to get accurate
output on the labels.
As anyone seen this? What did I miss?
Thanks,
-Monica
names and addresses. Not so weird. But the person who generated it did not
use a consistent format in the Zip Code field, so the zips beginning with
zero, were all Smart Tagged as "this cell is formatted as text or has an
apostrophe in it'. And they did - in a mixed manner. When my user tried to
make mailing labels, those beginning with zero only populated the label zip
field with a '0'. I tried everything, clearing the formats of the column,
resetting, copying and pasting as plain text, using the Special Format -
Zip Code setting, using Text format on all - nothing worked to get accurate
output on the labels.
As anyone seen this? What did I miss?
Thanks,
-Monica