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 Im 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?