merge percentages from excel to word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelzina - 01 Jan 2007 02:54 GMT

how do i keep the formatting when merging from excel to word
eg at the moment its transferring as...
excel 50%; $12.30
word .5 ; 12.3

thanx

Signature

"The difference between Possible and Impossible is the measure of ones will"

Reply to this Message

Doug Robbins - Word MVP - 01 Jan 2007 07:05 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

> how do i keep the formatting when merging from excel to word
> eg at the moment its transferring as...
> excel 50%; $12.30
> word .5 ; 12.3
>
> thanx

Reply to this Message

Kelzina - 04 Jan 2007 10:42 GMT

hi doug, thanks for your time, however im finding it hard to understand that
website. from what i can tell its saying to put code into word... but all im
wanting to do is get numeric data from excel and put it in word keeping the
same formatting. either what i'm looking for is there and im blind or that
website isn't exactly what i needed.
thank you anyway

Signature

"The difference between Possible and Impossible is the measure of ones will"

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 7 lines]
> >
> > thanx

Reply to this Message

Graham Mayor - 04 Jan 2007 10:51 GMT

The page is exactly what you need. Mail merge in Word 2002/3 uses only the
raw data from Excel. You must add formatting switches to your inserted
fields to achieve the results you require. Both types of field are covered
with examples of their use.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> hi doug, thanks for your time, however im finding it hard to
> understand that website. from what i can tell its saying to put code
[quoted text clipped - 26 lines]
>>> "The difference between Possible and Impossible is the measure of
>>> ones will"

Reply to this Message