If you want to format a number in contradiction of the regional settings, it
all tends to get a tad clumsy if working with fields. You could treat each
part of the number as a separate string eg 10000.00 would translate to 10
000 & .00
The following will work with amounts up to 99000 - after that you will have
to set up the number segments for hundred thousands and millions
{ Set x { MERGEFIELD Amount }
}{ SET TH { =INT({ x } / 1000) }
}{ SET HU { =INT({x }) - { =({ TH } * 1000 ) } }
}{ SET DE { =(({ x } - { =INT({ x}) }) * 100 \# "','00") } }
{ IF{x } 1000 "{ TH }."}{ HU }{ DE }
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
SRV wrote:
Thank you for the reply. This soultion will not work for me as client
did not accept this as a solution. Any other thoughts would really
help us.
"Doug Robbins - Word MVP" wrote:
Change the formatting in the control panel before executing the
merge.
--
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my
services on a paid professional basis.
"SRV" wrote in message
...
I have a mail merge which has numbers (amounts) to be formatted for
european
regional settings ( comma as decimal seperator and dot as grouping
seperator).
I tried the following but it did not work.
{ MERGEFIELD "Net_Amount" \# #.###,00 }
Using MS Office 2000 on Windows XP
Appreciate you quick reply