Mailmerge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jenny - 13 Aug 2007 20:14 GMT

My document is in word and my data source is in Excel. When I merge the two
files, my data shows as a decimal, but I need it to be a %, and $ sign is
drop from amounts - how can I get it to look just like it is in Excel?

Reply to this Message

Doug Robbins - Word MVP - 13 Aug 2007 20:52 GMT

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

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

Signature

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

> My document is in word and my data source is in Excel. When I merge the
> two
> files, my data shows as a decimal, but I need it to be a %, and $ sign is
> drop from amounts - how can I get it to look just like it is in Excel?

Reply to this Message

Sherry Phillips - 17 Aug 2007 01:54 GMT

Doug,

I'm having a little different problem with percentages. I'm merging from an
Excel spreadsheet and the percentage is calculated by a formula in Excel. No
matter what I do, it won't merge into Word correctly. Example: it changes
136.67 to 1.366666. I need for it to keep the exact number and format of
Excel. I tried some of the switches, but still didn't get the outcome I
want. Any ideas?

Thanks,
Sherry

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 5 lines]
> > files, my data shows as a decimal, but I need it to be a %, and $ sign is
> > drop from amounts - how can I get it to look just like it is in Excel?

Reply to this Message

Doug Robbins - Word MVP - 17 Aug 2007 04:20 GMT

What switches have you tried? You may need to use the Round() function in
Excel.

Signature

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

> Doug,
>
[quoted text clipped - 21 lines]
>> > is
>> > drop from amounts - how can I get it to look just like it is in Excel?

Reply to this Message