Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF then with merged date field from excel | Mailmerge | |||
Help to merge Image (Doug Robins?) | Mailmerge | |||
Make merged field bold if merged field is > 3 | Mailmerge | |||
Make merged field bold if merged field > 3 | Mailmerge | |||
Format a merged numeric field | Mailmerge |