Merged field includes extraneous numbers?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JB needs help! - 23 Nov 2006 00:03 GMT

When I use mail merge with Excel being the data source, one of the merged
fields adds extra numbers. For example, 5.263 becomes 5.262999999999. This
is not a formatting thing in Excel as the 5.263 is not driving off a formula
or anything (it's a manually entered number) and it is rounding to 3 decimal
such that if I add decimals it becomes 5.263000, etc. I have no idea where
the 9s are coming from and why it is rounding down.

PLEASE HELP!!!!

Reply to this Message

Doug Robbins - Word MVP - 23 Nov 2006 04:39 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

> When I use mail merge with Excel being the data source, one of the merged
> fields adds extra numbers. For example, 5.263 becomes 5.262999999999.
[quoted text clipped - 8 lines]
>
> PLEASE HELP!!!!

Reply to this Message

JB needs help! - 23 Nov 2006 05:57 GMT

Thanks so much Doug! It was for my girlfriend....you hooked me up!

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

Reply to this Message

Doug Robbins - Word MVP - 23 Nov 2006 22:17 GMT

Next time send your girlfriend.

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

> Thanks so much Doug! It was for my girlfriend....you hooked me up!
>
[quoted text clipped - 16 lines]
>> >
>> > PLEASE HELP!!!!

Reply to this Message