Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mail merge
I was just upgraded to windows XP. When I am in a word doc and perform a
mail merge, I select the existing Excel spreadsheet and merge. What comes thru is the whole value of my cells...for instance -3108.1355 when in Excel I have it formatted to be (3,108.14). I need the proper two decimal place number with the parenthesis to appear on my mail merge. |
#3
|
|||
|
|||
There are two ways to do this - the first is\covered in the Excel data
section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm , but the simpler method is to add a formatting switch to the field http://www.gmayor.com/formatting_word_fields.htm which in this instance would be \# ",0.00;(,0.00)" -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Omega Linda wrote: I was just upgraded to windows XP. When I am in a word doc and perform a mail merge, I select the existing Excel spreadsheet and merge. What comes thru is the whole value of my cells...for instance -3108.1355 when in Excel I have it formatted to be (3,108.14). I need the proper two decimal place number with the parenthesis to appear on my mail merge. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
Mail Merge - Parameter prompts twice... | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge |