Thanks guys - what would the mail merge community do without you all!
--
Regards
Andy
Andy Roberts
Win XP, Office 2007
"Andy Roberts" wrote in message
...
Peter
Thanks for your response. I get a syntax error when I use your
suggestion. I add a field code using ctrl+F9 then insert your suggestion
minus the first and last {}.
--
Regards
Andy
Andy Roberts
Win XP, Office 2007
"Peter Jamieson" wrote in message
...
try
{ =int({ MERGEFIELD mynumber }*10)/10 }
where all the {} are the special field code brace pairs that you can
insert using ctrl-F9, and "mynumber" is the name of your mergefield.
Peter Jamieson
http://tips.pjmsn.me.uk
On 04/04/2010 16:32, Andy Roberts wrote:
I have a number being merged from excel which is formatted to 1 decimal
place in excel (e.g. 1.6). When it comes through to word as part of the
mail merge it displays as a true number (1.666666666666667) and I want
it to
display to 1dp. I'm aware of switches to control formatting but don't
know
how to do this with number formats / decimal places within the word doc.
Can anyone shed light on it?