merge percentages from excel to word

[Kelzina]

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

 

[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

 

[Kelzina]

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
--
"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

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

 

[Graham Mayor]

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.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>