MERGE WITH EXCEL FILE

MERGE WITH EXCEL FILE - , FORMAT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SOS AHQ - 16 May 2008 05:23 GMT

I have made an excel file and merged it with word. I have noticed that
formating which I have applied in excel is not appear, like I am using ,
(comma) format as 12,000 but it shows 12000. Further I want that the format
should appear in word file as it as I have applied in excel file.

What should I do, please advise.

Reply to this Message

Graham Mayor - 16 May 2008 06:20 GMT

Word merge doesn't use the formatting in Excel. You would have to apply the
formatting by means of a switch - see
http://www.gmayor.com/formatting_word_fields.htm

For 12000 to 12,000 you would need {MERGEFIELD Numberfieldname \# ",0" }

Signature

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

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

> I have made an excel file and merged it with word. I have noticed that
> formating which I have applied in excel is not appear, like I am
[quoted text clipped - 3 lines]
>
> What should I do, please advise.

Reply to this Message