Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JB needs help! JB needs help! is offline
external usenet poster
 
Posts: 1
Default Merged field includes extraneous numbers?

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!!!!

  #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 Merged field includes extraneous numbers?

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

"JB needs help!" JB needs wrote in message
...
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!!!!



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JB needs help! JB needs help! is offline
external usenet poster
 
Posts: 1
Default Merged field includes extraneous numbers?

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



"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

"JB needs help!" JB needs wrote in message
...
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!!!!




  #4   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 Merged field includes extraneous numbers?

Next time send your girlfriend.

--
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

"JB needs help!" wrote in message
...
Thanks so much Doug! It was for my girlfriend....you hooked me up!



"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

"JB needs help!" JB needs wrote in
message
...
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
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
IF then with merged date field from excel Holly Mailmerge 3 January 14th 06 07:05 AM
Help to merge Image (Doug Robins?) JohnB Mailmerge 21 June 23rd 05 05:28 PM
Make merged field bold if merged field is > 3 Vick Mailmerge 3 December 15th 04 02:32 PM
Make merged field bold if merged field > 3 Vick Mailmerge 1 December 13th 04 04:26 PM
Format a merged numeric field Hema Mailmerge 1 December 8th 04 12:51 AM


All times are GMT +1. The time now is 05:46 PM.

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

About Us

"It's about Microsoft Word"