Word/Excel Mail Merge Formatting Problems

[Michele]

I'm creating a format letter for our company payout of the
annual bonus. On each letter, there will be a chart
containing the variables that help us arrive at each
indivduals percentages and payout. My problem is that the
format from the excel spreadsheet is not carryover. So
instead of having the following:

29.25% 117.01% $68,750 $11,618

I'm getting this:

29.253124637 117.0125687423 68750 11618

What's going on? I've gone through the mail merge wizard
and it's hitting the right fields, but none of the
formatting is carrying over...

Thanks!
Michele

 

[Michele]

I've managed to figure out the $ formatting. But I still
cannot get the % to work properly. The following is the
fieldcode that is currently being used, however it's only
displaying .10% instead of 10% (the % is hardcoded into
the letter):

{MERGEFIELD "F"}%

I've also tried the following but with no result:

{= 100 * {MERGEFIELD "F"} \ #0%}


Addtionally, I need the date format in the letter to come
out as follows (like it is in the spreadsheet):

DD-MON-YR (i.e. 17-Feb-04

Currently it's reading as 02/17/04

Thank you again!
Michele

 

[jairianaBusMgr]

Michelle,

Would you tell me how you figured of the $ formatting as I
am having the same problem and can't seem to get it
figured out.

Thanks
Judy

 

[Peter Jamieson]

Did you use ctrl-F9 to insert both sets of field braces(the {} braces) in
the nested expression?

FWIW I would probably lay out the expression like this:

{ ={ MERGEFIELD "F" }*100 \#0% }

DD-MON-YR (i.e. 17-Feb-04

Currently it's reading as 02/17/04

{ MERGEFIELD yourdatefield \@MM-DDD-YY }

 

[Guest]

Judy,

I did the following"

Alt + F9

${MERGEFIELD \ #"#,##0"}

HTH
Michele

 

[Guest]

Peter,

Thanks for the tip on the date. Worked like a charm.
Still having problem with the %, keep getting syntax
error.

I've entered the following:

{={MERGEFIELD "F"}*100 \# 0%} as suggested... Any other
suggestions or help?

Thanks again!
Michele

 

[Graham Mayor]

Are you sure you have \# and not /# which would throw an error.
Have you updated the field (F9) after making the changes?
Have you tried bracketing eg

{=({MERGEFIELD "F"}*100) \# "0%"}

Did you insert the second set of {} with CTRL+F9?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Larry]

Michele, I am having a similar problem. Request being
included in any responses. Thank you.

 

[Nikki]

I'm having a similar problem with 9-digit zip codes. They will merge from data sources formatted as 9-digit zips, but the hyphen is missing.

 

[Graham Mayor]

I'm having a similar problem with 9-digit zip codes. They will merge
from data sources formatted as 9-digit zips, but the hyphen is
missing.

This is covered at http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Peter Jamieson]

Where are you getting the date data from, and what does it look like there
(e.g. is it a date in an Excel sheet, and if so, what does it look like when
you display it in Excel?)

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

I tried what you suggested for the date format, but I have one merged date

field that keeps coming up as a numeric date... ie 37777, and I cannot get
it to change to MMM DD, YYYY. Any other suggestions?

 

[Ramona]

Did you get my last message? I am using Excel and the date format shows as 01/01/01 in the formula bar, but January 1, 2001 in the cell (of course this is just the format not the acutal date

I am getting 36666 (format again not actual number) in my Word document.

 

[Graham Mayor]

It helps if you include the message you are referring to in your post - the
respondents here access via the news server and don't retain the original
messages very long

See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm which should
resolve your problem.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Peter Jamieson]

Did you get my last message?

No. I didn't.

Are all the cells in this column formatted the same way? There could be a
problem if the first few (probably 8) rows do not have dates and the column
is assumed to have numeric format rather than a date format.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

Did you get my last message? I am using Excel and the date format shows

as 01/01/01 in the formula bar, but January 1, 2001 in the cell (of course
this is just the format not the acutal date)