[Peter Jamieson]

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?

[Andy Roberts]

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?

[Doug Robbins - Word MVP]

If it can be done, it will almost certainly be in fellow MVP Macropod's Word
Field Maths Tutorial at:

http://lounge.windowssecrets.com/ind...owtopic=365442

or at:

http://www.gmayor.com/downloads.htm#Third_party

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

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

[macropod[_2_]]

Hi Andy,

Peter's code had *two* fields - one inside the other. Thus, you need to press Ctrl-F9 twice to create a nested pair of fields (ie
'{{ }}') then fill in/around them to get:
{=INT({ MERGEFIELD mynumber}*10)/10 \# 0.0}


--
Cheers
macropod
[Microsoft MVP - Word]


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

[Andy Roberts]

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?