Word - Word 2007 Mail Merge losing number formatting

Asked By mostly confused

28-Jan-10 02:27 PM

I am doing a mail merge in Word 2007 and I am losing the number formatting
from Excel.  Copy & paste special is not an option as I need the data to
remain in Excel as it is.
--
mostly confused

28-Jan-10 02:37 PM

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm


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

29-Jan-10 09:24 AM

Doug,

Thanks, this did help however, it is not working for my percentages.  The
decimal ends up in the wrong place.
--
mostly confused

29-Jan-10 10:02 AM

The decimal should not be in the wrong place if you follow the instructions,
however much depends on what the field produces without the calculation.

--
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

29-Jan-10 11:53 AM

When I tried the percentage { ={ MERGEFIELD Amount} * 100\# "0% "}, I get
--
mostly confused

29-Jan-10 12:07 PM

All the special field brace pairs {} need to be the sort you can insert
using ctrl-F9. So you can do

1. ctrl-F9 to give you...

{ }

2. type
=  * 100 \#0%
to give you

{ =  * 100 \#0% }

3. click immediately after the "=" then click ctrl-F9 to give you
{ = { } * 100 \#0% }

4. Between the new { }, type
MERGEFIELD Amount

to give you

{ = { MERGEFIELD Amount } * 100 \#0% }


Peter Jamieson

http://tips.pjmsn.me.uk

29-Jan-10 12:23 PM

Got it - my error CTRL F9 - works like a charm!  Thank you, thank you, thank
you!!
--
mostly confused

30-Jan-10 03:14 AM

The requirement to use CTRL+F9 for field brackets is at the top of the web
page in a large red coloured typeface! :(

--
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org