If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Displaying currency in mail merge documents
how do you get numbers to display as currency (i.e. as $1,000.00 not 1000) in
mail merge fields? i've tried saving the data source as text, excel and access. in access, the fields are formatted as currency and appear correctly, but when merging into publisher, they lose the dollar sign, comma and .00 (for whole dollar amounts). |
#2
|
|||
|
|||
If you format the fields in Access or Excel as text the merge will display correctly.
-- Mary Sauer MS MVP http://office.microsoft.com/ http://www.msauer.mvps.org/ news://msnews.microsoft.com "lf" wrote in message ... how do you get numbers to display as currency (i.e. as $1,000.00 not 1000) in mail merge fields? i've tried saving the data source as text, excel and access. in access, the fields are formatted as currency and appear correctly, but when merging into publisher, they lose the dollar sign, comma and .00 (for whole dollar amounts). |
#3
|
|||
|
|||
But when I format the fields as text, I lose the $, comma and .00.
I need 1000 to display as $1,000.00 in the Publisher mail merge document. "Mary Sauer" wrote: If you format the fields in Access or Excel as text the merge will display correctly. -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.msauer.mvps.org/ news://msnews.microsoft.com "lf" wrote in message ... how do you get numbers to display as currency (i.e. as $1,000.00 not 1000) in mail merge fields? i've tried saving the data source as text, excel and access. in access, the fields are formatted as currency and appear correctly, but when merging into publisher, they lose the dollar sign, comma and .00 (for whole dollar amounts). |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word-Excel 2003 - Mail Merge Recipients problem | Gabbi | Mailmerge | 4 | January 11th, 2005 04:11 AM |
Mail Merge Problem w/ MS Word 2000 | pkampa(removethis)@optonline.net | Mailmerge | 2 | December 28th, 2004 08:51 PM |
Customize a Mail Merge doc | Neh | Mailmerge | 1 | September 1st, 2004 12:47 AM |
Mail Merge error on existing documents | Rachel | Mailmerge | 0 | July 19th, 2004 06:59 AM |