Merge problems with Excel 2003 and Word 2003

R

RandyH

We're trying to merge in currency fields from excel, the cells are set up to
display $0,000.00 when actually the value could be $0,000.00000000 as seen
in the formula bar. When merged into word that's what we get 0,000.0000000
when we only want $0,000.00. Help says that the data source format doesn't
matter to Word and will be able to modify the format to display the data how
ever we choose...but when we "edit field" NumChars...and select
$#,##0.00;($#,##0.00) our number changes to $5.00....

tia for any help or comments...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Word 2013 DDE merge to Excel file 0
Mail merge hyperlink wrong results 0
Paste to excel from word - auto format problem 1
Linking data in MS Word into Excel 5
Long Data Fields in Mail Merge 0
Formatting Percentage from Excel Data 1

Top