| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commas drop off of number in mail merge to into Word
Does anyone know why when I mail merge using Excel 2007 into Word why
the commas drop off of the numbers shown in my columns? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Commas drop off of number in mail merge to into Word
Check out this link...
http://www.gmayor.com/formatting_word_fields.htm -- HTH... Jim Thomlinson "glamisgrl" wrote: Does anyone know why when I mail merge using Excel 2007 into Word why the commas drop off of the numbers shown in my columns? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Commas drop off of number in mail merge to into Word
Thank you. Forgive my ignorance but if this is my merge field
«Market_Value» what exactly would I add to it to keep the commas in place? "Jim Thomlinson" wrote: Check out this link... http://www.gmayor.com/formatting_word_fields.htm -- HTH... Jim Thomlinson "glamisgrl" wrote: Does anyone know why when I mail merge using Excel 2007 into Word why the commas drop off of the numbers shown in my columns? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Commas drop off of number in mail merge to into Word
In article , ?B?Z2xhbWlzZ3Js?= wrote:
Thank you. Forgive my ignorance but if this is my merge field «Market_Value» what exactly would I add to it to keep the commas in place? Suggest you use the DDL option when getting the data. That fixed a number of odd word formatting problems in an earlier xl/word version. "Jim Thomlinson" wrote: Check out this link... http://www.gmayor.com/formatting_word_fields.htm -- HTH... Jim Thomlinson "glamisgrl" wrote: Does anyone know why when I mail merge using Excel 2007 into Word why the commas drop off of the numbers shown in my columns? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Commas drop off of number in mail merge to into Word
Hope this is correct protocol to add my experience.
I use mail-merge to print ham radio certificates, and originally imported a tab-delimited .txt file, and the commas in the score were printed. But I found that mal-merge would simply stop printing after several hundred when I used the tab-delimited file, so I imported that file into excel, and found all 2000 certificates were printed with no glitch, but then discovered that, even though the comma is displayed in excel, it is not printed by mail merge. So, I dropped back, use the tab-delimited .txt file, and print 100 at a time and all is well, no hangs, and the scores have commas. On Jul 22, 11:47*pm, (Bruce Sinclair) wrote: In article , ?B?Z2xhbWlzZ3Js?= wrote: Thank you. Forgive my ignorance but if this is my merge field «Market_Value» what exactly would I add to it to keep the commas in place? Suggest you use the DDL option when getting the data. That fixed a number of odd word formatting problems in an earlier xl/word version. "Jim Thomlinson" wrote: Check out this link... http://www.gmayor.com/formatting_word_fields.htm -- HTH... Jim Thomlinson "glamisgrl" wrote: Does anyone know why when I mail merge using Excel 2007 into Word why the commas drop off of the numbers shown in my columns?- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merge from XL to word | Excel Discussion (Misc queries) | |||
| how to mail merge zero to word | Excel Discussion (Misc queries) | |||
| How come Word is adding zeros to a mail merge number from Excel? | Excel Worksheet Functions | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| Mail Merge into Word 97 | Excel Discussion (Misc queries) | |||
Linear Mode
