Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
In mail merge from an excel source the number fields are too long
When previewing the merge data the numbers from the excel data sourse have
too many digits - ie $ 15.6789678002. In the excel source the cell format is set to 2 places only as either a number or currency. How do I get the 2 places to stay in tact in the document. Also it dropps the 0's when they need to be there such as $1.50 is showing as $1.5. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
In mail merge from an excel source the number fields are too long
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 "rilab" wrote in message ... When previewing the merge data the numbers from the excel data sourse have too many digits - ie $ 15.6789678002. In the excel source the cell format is set to 2 places only as either a number or currency. How do I get the 2 places to stay in tact in the document. Also it dropps the 0's when they need to be there such as $1.50 is showing as $1.5. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge with separate Source Header document | Mailmerge | |||
Numeric rounding problems in mail merge with excel data source. | Mailmerge | |||
Mail Merge: Excel (XP) fields scrambled during merge | Mailmerge | |||
mail merge using excel file as data source | Mailmerge | |||
How do I mail merge fields exceeding 255 characters from Excel to. | Mailmerge |