Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mostly confused mostly confused is offline
external usenet poster
 
Posts: 4
Default Word 2007 Mail Merge losing number formatting

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2007 Mail Merge losing number formatting

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

"mostly confused" wrote in
message ...
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


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mostly confused mostly confused is offline
external usenet poster
 
Posts: 4
Default Word 2007 Mail Merge losing number formatting

Doug,

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


"Doug Robbins - Word MVP" wrote:

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

"mostly confused" wrote in
message ...
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


.

  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Word 2007 Mail Merge losing number formatting

The decimal shouldn't 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



"mostly confused" wrote in
message ...
Doug,

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


"Doug Robbins - Word MVP" wrote:

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

"mostly confused" wrote in
message ...
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


.



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mostly confused mostly confused is offline
external usenet poster
 
Posts: 4
Default Word 2007 Mail Merge losing number formatting


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


"Graham Mayor" wrote:

The decimal shouldn't 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



"mostly confused" wrote in
message ...
Doug,

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


"Doug Robbins - Word MVP" wrote:

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

"mostly confused" wrote in
message ...
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

.



.



  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Word 2007 Mail Merge losing number formatting

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

On 29/01/2010 16:53, mostly confused wrote:

When I tried the percentage { ={ MERGEFIELD Amount} * 100\# "0% "}, I get
"!Syntax Error, {"

  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mostly confused mostly confused is offline
external usenet poster
 
Posts: 4
Default Word 2007 Mail Merge losing number formatting


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


"Graham Mayor" wrote:

The decimal shouldn't 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



"mostly confused" wrote in
message ...
Doug,

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


"Doug Robbins - Word MVP" wrote:

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

"mostly confused" wrote in
message ...
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

.



.

  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Word 2007 Mail Merge losing number formatting

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




"mostly confused" wrote in
message ...

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


"Graham Mayor" wrote:

The decimal shouldn't 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



"mostly confused" wrote in
message ...
Doug,

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


"Doug Robbins - Word MVP" wrote:

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

"mostly confused" wrote in
message ...
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

.



.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007 losing formatting Jo Page Layout 1 May 12th 08 06:51 PM
Formatting A Number In Mail Merge George Microsoft Word Help 1 August 23rd 06 05:42 PM
How do you preserve number formatting in a mail merge? jb52 Mailmerge 1 February 2nd 06 08:25 PM
Mail merge number formatting Lindie Mailmerge 1 October 5th 05 09:32 PM
Formatting Number Values from Mail Merge jdawgnat Mailmerge 8 May 27th 05 03:35 PM


All times are GMT +1. The time now is 06:21 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"