Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word/Excel
Any ideas as to why when merging to word from an excel database numerical
entries such as 7.8, or 899.3, will transfer to word as 7.877777777779, or 899.32222222222223, etc. And yet in some cases it doesn't. We have tried merging to a world table document as well as a word letter document, no difference. The cells in Excel are formatted to Text (although the data was originally entered using General formatting). Any thoughts |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word/Excel
Hi Anthony,
You're getting that result because that's what's really in the Excel cells. You can control how the data are displayed by adding a numeric picture switch to the mergefield. To do this: .. select the mergefield; .. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData}; .. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below); .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: .. \# 0 for rounded whole numbers .. \# ,0 for rounded whole numbers with a thousands separator .. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator .. \# $,0 for rounded whole dollars with a thousands separator .. \# $,0.00;($,0.00);'-' for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed. Note that this suppresses 0s resulting from empty fields and from fields containing 0s. -- Cheers macropod [Microsoft MVP - Word] "Anthony" wrote in message ... Any ideas as to why when merging to word from an excel database numerical entries such as 7.8, or 899.3, will transfer to word as 7.877777777779, or 899.32222222222223, etc. And yet in some cases it doesn't. We have tried merging to a world table document as well as a word letter document, no difference. The cells in Excel are formatted to Text (although the data was originally entered using General formatting). Any thoughts |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word/Excel
Anthony was telling us:
Anthony nous racontait que : Any ideas as to why when merging to word from an excel database numerical entries such as 7.8, or 899.3, will transfer to word as 7.877777777779, or 899.32222222222223, etc. And yet in some cases it doesn't. We have tried merging to a world table document as well as a word letter document, no difference. The cells in Excel are formatted to Text (although the data was originally entered using General formatting). Any thoughts macropod says it all in this post: http://tiny.cc/6XeHj -- ______________________________ Jean-Guy Marcil Montreal, Canada |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word/Excel
macropod was telling us:
macropod nous racontait que : Hi Anthony, You're getting that result because that's what's really in the Excel cells. You can control how the data are displayed by adding a numeric picture switch to the mergefield. To do this: . select the mergefield; . press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData}; . edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below); . position the cursor anywhere in this field and press F9 to update it; . run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: . \# 0 for rounded whole numbers . \# ,0 for rounded whole numbers with a thousands separator . \# ,0.00 for numbers accurate to two decimal places, with a thousands separator . \# $,0 for rounded whole dollars with a thousands separator . \# $,0.00;($,0.00);'-' for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed. Note that this suppresses 0s resulting from empty fields and from fields containing 0s. LOL I just send the poster to one of your replies to another poster (from April 24) that contains the exact same text! -- ______________________________ Jean-Guy Marcil Montreal, Canada |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word/Excel
Hi Jean-Guy Marcil,
The same Qs keep popping up, so having some boilerplate text is handy. -- Cheers macropod [Microsoft MVP - Word] "Jean-Guy Marcil" wrote in message ... macropod was telling us: macropod nous racontait que : Hi Anthony, You're getting that result because that's what's really in the Excel cells. You can control how the data are displayed by adding a numeric picture switch to the mergefield. To do this: . select the mergefield; . press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData}; . edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below); . position the cursor anywhere in this field and press F9 to update it; . run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: . \# 0 for rounded whole numbers . \# ,0 for rounded whole numbers with a thousands separator . \# ,0.00 for numbers accurate to two decimal places, with a thousands separator . \# $,0 for rounded whole dollars with a thousands separator . \# $,0.00;($,0.00);'-' for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed. Note that this suppresses 0s resulting from empty fields and from fields containing 0s. LOL I just send the poster to one of your replies to another poster (from April 24) that contains the exact same text! -- ______________________________ Jean-Guy Marcil Montreal, Canada |
Reply |
Thread Tools | |
Display Modes | |
|
|