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
|
|||
|
|||
Formatting Field In Mail-Merge
I have a Word document that uses excel as the data source. I need to display zeros in the some of the fields and number with commas in those same fields. I used the sitch \###,###,###,###. The numbers worked fine but my zeros didn't come thru.
Any help would be greatly appreciated. Thanks... J... |
#2
|
|||
|
|||
I am having this same problem with Access. I have a currency amount of $900.00 that I want to come over exactly like that, but it just comes over as 900. I tried what Jerry discussed with the switch (I used \###,###.##) but I only got 900. back (it added the decimal). This is so frustrating! Anybody have any thoughts??? Thanks!
Ryan Quote:
|
#3
|
|||
|
|||
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 "RyanP" wrote in message ... I am having this same problem with Access. I have a currency amount of $900.00 that I want to come over exactly like that, but it just comes over as 900. I tried what Jerry discussed with the switch (I used \###,###.##) but I only got 900. back (it added the decimal). This is so frustrating! Anybody have any thoughts??? Thanks! Ryan Jerry Wrote: I have a Word document that uses excel as the data source. I need to display zeros in the some of the fields and number with commas in those same fields. I used the sitch \###,###,###,###. The numbers worked fine but my zeros didn't come thru. Any help would be greatly appreciated. Thanks... J... -- RyanP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
hyperlink in mail merge field | Andre | Mailmerge | 0 | September 9th, 2004 11:25 PM |
Mail Merge - Field Calculation Error Occurred on Word XP | Mal Wilson | Mailmerge | 2 | August 23rd, 2004 01:51 PM |
Retaining source formatting from Excel with a mail merge in Word | Drew | General Discussion | 2 | August 18th, 2004 07:34 AM |
Multiple Names In A Mail Merge Field | Traci | New Users | 3 | June 30th, 2004 03:51 AM |
Problem formatting ZIP code in mail merge | Peter Serratore | Setting up and Configuration | 6 | October 18th, 2003 01:50 AM |