Problems With Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marlin - 07 Sep 2005 15:55 GMT

Good Day Everyone.

Have a problem with mail merge and hoped someone out there can help.
Driving me nuts!

Using Excel spreadsheet as data file, numbers that are formatted to round to
2 decimal places merge into word without rounding. Example - 1.20 merges in
as 1.19873364456532333 etc.

Cannot figure out how to get the rounded number merged in. ANY help is
appreciated. Please respond to mparrott(removethis)@mada.com Thanks!

Marlin

Reply to this Message

Doug Robbins - 07 Sep 2005 19:25 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

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

> Good Day Everyone.
>
[quoted text clipped - 11 lines]
>
> Marlin

Reply to this Message

pdjpirate - 13 Sep 2005 05:59 GMT

Outstanding Doug! I had been experiencing this problem as well. To compound
it, this problem was holding up about $47,000 in billing! But not any more!!!

Unfortunately, I cannot share any with you for your services, it happens to
belong to the tax payers of this great land. Look at it this way, you just
did your civic duty for the week!

Thanks again! All the best!

pdjpirate

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 16 lines]
> >
> > Marlin

Reply to this Message

Doug Robbins - 13 Sep 2005 23:02 GMT

Not sure to what "great land" you are refering, but almost certainly, it is
not one from which I receive any benefits.

Seeking benefits however is not the reason I am here and as far as I am
concerned, this community is not restricted to any one land, great or small.

Signature

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

> Outstanding Doug! I had been experiencing this problem as well. To
> compound
[quoted text clipped - 33 lines]
>> >
>> > Marlin

Reply to this Message