lossing formatting in merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

your best friend - 10 Jan 2004 23:51 GMT

I have been trying in vain to transfer the data I see into a word document, but everytime i do this all formatting and decimel places just get mixed up or lost and the numbers are 15 digits long. After reading oll the entries on merge filed switches i knew there had to be an easier way of controlling the way the data was transfered AND THERE IS:

The easiest method to keep all formatting when merging data from excel to word is to turn on the "prescsion as displayed" option in the options - Caluculation box under the tools menu

This way all data as displayed on your worksheet will be merged into the word document and all formating such as formula, rounding up and deceimel placing etc are not lost in the transfer

NO MORE SWITCHES JUST WYSIWY

I hope this helps a lot of people

Reply to this Message

a helper - 12 Jan 2004 22:46 GMT

Hi. I tried your suggestion, but still had no success.

I turned on the "precision on as displayed" in my excel file. Saved it. Remerged it and still lost the formatting. Is there something else I can do? Thanks

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 13 Jan 2004 06:44 GMT

See the following page of fellow MVP Graham Mayor's website:

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

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

> Hi. I tried your suggestion, but still had no success.
>
> I turned on the "precision on as displayed" in my excel file. Saved it.
> Remerged it and still lost the formatting. Is there something else I can
> do? Thanks

Reply to this Message

Graham Mayor - 13 Jan 2004 09:04 GMT

See also the Excel data section of companion web page
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL
ADDRESS wrote:

> See the following page of fellow MVP Graham Mayor's website:
>
[quoted text clipped - 11 lines]
>> it. Remerged it and still lost the formatting. Is there something
>> else I can do? Thanks

Reply to this Message