Currency Format When Merging into Word

P

pennyb

I have a database file set up in Excel 2003 and my columns are formatted as
currency with the $ symbol. However, when I merge my data into my Word mail
merge file the $ symbol will not show up and the number isn't displayed with
decimal points. For example: $90.00 would show up as 90---how can I fix this?
 
B

Billy Liddel

Penny

I seem to remember that you can right-click the field in Word and choose
formatting, and correct the format from there.

Regards
Peter
 

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
Merging from an Excel file with graphics 1
Mail Merge Directory Conditional Page Break 0
ASK Field Formatting 1
Merge Excel file into Word Document 3
Mail Merge skipping records/sending one at a time 0
How to break up a book's endnotes by chapter in a file containing a whole book? 0
Excel does not accept text format! 0

Top