mail merge number format

[klav]

I have a VBA project to merge a lot of word docs with excel charts.

I have an excel chart with a custom format to display millions as "33.5
million" but when I merge it with my word doc, the formatting is lost and the
entire number is displayed "33500000". I know within a main document, you can
specify field formats but I am unable to get this number displayed the way I
want it.

Is there a way either within the merge field coding or within VBA to do this?

 

[Graham Mayor]

If all the numbers are above 1 million, you could use
{ ={ Mergefield Amount } / 1000000 } million

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


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