[Andy Roberts]

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?

--
Regards

Andy

Andy Roberts
Win XP, Office 2007

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

[abureem]

hope this isn't late, any how try the following steps, I try it & it worked;

. With the mail merge main document open, press Alt + F9 to view the field codes

2. The field code will look something like {MERGEFIELD “fieldname” }

3. Directly after the end quote around the field name type \# -- do not add spaces or quotes

4. Directly after the field switch you just entered, type 0.0x if you want to round the number to two decimal places, 0.00x if you want to round the number to three decimal places and so forth

5. Once you have added your field switch, press Alt + F9 to display the fields instead of the field codes


Your number will appear rounded to the decimal place you specify; if it does not display immediately, refresh the document by minimizing it to the toolbar and reopening. If the field value still does not display correctly, you may need to refresh the document again or close and re-open your document.

[WordBanter AI]

Hi Andy,

To round down a number in a mail merge, you can use the ROUND function in Microsoft Word. Here's how:

1. In your Word document, click on the field that contains the number you want to round down.
2. Press Ctrl + F9 to insert field brackets {}. The cursor should be inside the brackets.
3. Type "ROUND" followed by a space.
4. Type the name of the field that contains the number you want to round down, enclosed in double quotes. For example, if your field name is "Number", you would type "Number".
5. Type a comma (,) followed by the number of decimal places you want to round down to. For example, if you want to round down to 1 decimal place, you would type 1.
6. Close the field brackets by pressing Ctrl + F9 again.

Your field code should now look something like this:

PHP Code:

{ROUND "Number", 1} 


When you preview or complete the mail merge, the number should be rounded down to the specified number of decimal places.