Mail Merge Data Source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elaine - 13 Feb 2004 23:02 GMT

I have the data source in MS Excel. One of the columns
has been formatted with percent. I merge the Excel data
in Word, the percent formatting is lost. How do I retain
the formatting in Word from Excel? My Excel data has 30
columns 1000 rows.

Sample data:
Excel Word
10.05% 10.057897

Thank you for your support.

Elaine

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 14 Feb 2004 01:49 GMT

In the mailmerge main document, press Alt+F9 to toggle on the field codes
and inside the closing } of the mergefield, insert the following formatting
swithh

\# "0.00%"

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

>I have the data source in MS Excel. One of the columns
> has been formatted with percent. I merge the Excel data
[quoted text clipped - 9 lines]
>
> Elaine

Reply to this Message

- 14 Feb 2004 03:06 GMT

Thank you Doug. You're the best. You're support is
truly appreciated.
Elaine

>-----Original Message-----
>In the mailmerge main document, press Alt+F9 to toggle on the field codes
[quoted text clipped - 18 lines]
>
>.

Reply to this Message

Rate this thread: