MERGE WITH EXCEL FILE - , FORMAT

[SOS AHQ]

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.

 

[Graham Mayor]

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

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


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