| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
MERGE WITH EXCEL FILE - , FORMAT
I have made an excel file and merged it with word. I have noticed that
formating which I have applied in excel is not appear, like I am using , (comma) format as 12,000 but it shows 12000. Further I want that the format should appear in word file as it as I have applied in excel file. What should I do, please advise. |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
MERGE WITH EXCEL FILE - , FORMAT
Word merge doesn't use the formatting in Excel. You would have to apply the
formatting by means of a switch - see http://www.gmayor.com/formatting_word_fields.htm For 12000 to 12,000 you would need {MERGEFIELD Numberfieldname \# ",0" } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SOS AHQ wrote: I have made an excel file and merged it with word. I have noticed that formating which I have applied in excel is not appear, like I am using , (comma) format as 12,000 but it shows 12000. Further I want that the format should appear in word file as it as I have applied in excel file. What should I do, please advise. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail Merge an excel file to word- loss of format | Microsoft Word Help | |||
| How to format a file from Sxc, so I can read in word/excel? | Microsoft Word Help | |||
| Percentage format in merge from excel | Mailmerge | |||
| Word mail merge ,label format ,using an Excel file. | Mailmerge | |||
| mail merge from excel that changes my format from UK to US format | Mailmerge | |||
Linear Mode
