Reply
 
Thread Tools Display Modes
  #1   Report Post  
John
 
Posts: n/a
Default Formatting fields in Word (using Excel as Mail Merge Data) - need.

I have a Word document set up as a Mail Merge, using an Excel worksheet as my
data source. I am comparing two fields - current month sales vs. same month
last year, to get a sales ratio. I formatted the result in Excel so that
when the answer is, say "0.354", I get "35.4%". When I bring that "result"
field over into Word, I still get the "0.354". How do I format the
mail-merge field to show percentages (and even better would be to show a "+"
and "-" sign to indicate the appropriate fluctuation)?
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

To do the calculation you need to get 35.4 from 0.354, use e.g.

{ =100*{ MERGEFIELD mypercentagefield } }

Then use a numeric format switch to format the data, e.g.

{ =100*{ MERGEFIELD mypercentagefield } \#"+0.0%" }

where all the {} are inserted using ctrl-F9.

It's probably simpler to specify the maximum number of zeroes after the
decimal point that you use, e.g. if it is two, use
\#"+0.00%", and accept that Word will display trailing zeroes.

Peter Jamieson

"John" wrote in message
...
I have a Word document set up as a Mail Merge, using an Excel worksheet as
my
data source. I am comparing two fields - current month sales vs. same
month
last year, to get a sales ratio. I formatted the result in Excel so that
when the answer is, say "0.354", I get "35.4%". When I bring that
"result"
field over into Word, I still get the "0.354". How do I format the
mail-merge field to show percentages (and even better would be to show a
"+"
and "-" sign to indicate the appropriate fluctuation)?



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
1st word in heading flush left second word flush right Elin New Users 9 April 4th 05 08:44 PM
Losing format upon ENTER Jeff D'Amelio Page Layout 2 March 30th 05 11:31 PM
how can you create quickwords in MS Office Word 2003 Christine S Microsoft Word Help 4 February 8th 05 03:01 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
How to change merge forms from Word Perfect to Microsoft Word dollfindance Microsoft Word Help 2 December 30th 04 03:35 PM


All times are GMT +1. The time now is 08:24 PM.

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"