Home |
Search |
Today's Posts |
#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... -- Jerry |
#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 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 |
#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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge field different in datasource & insert a field menu | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Formatting a percentage mail merge field | Microsoft Word Help | |||
How to remove unwanted formatting in mail merge for cells witn no | Mailmerge | |||
formatting percent field using mail merge | Mailmerge |