> Sorry - this does not work in Word 2007 (SP1). It says
>
> !Syntax Error, {
>
> where the formatted number should be.
>
> RW
>
>
> "Graham Mayor" wrote:
>
>> You need a calculated field to divide by 1000000 i.e.
>>
>> {={Mergefield Fieldname} / 1000000 \# "$,0.000m"}
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site
http://word.mvps.org>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>>
>>
>>
>>
>> Ron West wrote:
>>> Hi, I've been given the task of fixing a Mail Merge that worked fine
>>> in Office 2000 but loses the Excel cell-formatting when run under
>>> Office 2007. I understand this is due to the new Office using some
>>> form of ADO instead of DDE to transfer the data.
>>>
>>> So, I've been looking at Word formatting pages such as
>>>
http://www.gmayor.com/formatting_word_fields.htm but I'm still
>>> having a lot of trouble getting anything remotely complex to work in
>>> Word 2007.
>>>
>>> My need is to take a number such as 12345678000 from an Excel
>>> cell and format it in Word as £12,345.678m (ie, shown to 3
>>> decimal places of millions).
>>>
>>> The original formatting string in Excel was £#,##0.000,,"m"
>>> (which seems to auto-divide by 1 million for display purposes as
>>> well as format the number) and I have tried to base my Word
>>> MERGEFIELD format string on this but with no success.
>>>
>>> I have so far only succeeded in getting the merged field to be
>>> formatted as £12,345,678,000 using \# "£#,##0"
>>>
>>> I have tried all sorts of formats and intermediate-value-formulae
>>> including "SET ..." and "/ 1000000" but nothing works.
>>>
>>> Can anyone help, please?