Why is formating (zip & phone) lost when merging from Excel to Wo.

[Stefan64]

When using office 2003, I want to merge my data from Excel to Word (labels,
letters, etc.) and the formatting for the zip code and telephone # is lost.
Example - in Excel the zip code is 06051 but when merged it is 6051, and the
phone # in Excel is (###) ###-#### and when merged is ##########.
how can this be resolved???

 

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Gladys]

Laymans Term

Merge as normal
In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with phone number formats.
For example:
{ MERGEFIELD "Phone" \# "(###)'-'####" }
4. Press Alt+F9 to hide the field codes.
5. Update all labels
5. Save the Main Document