| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
data format error
Thanks, it works.
"Graham Mayor" wrote in message ... See also http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi, You'll probably find that your Excel data really is as Word shows it, but you've got the cells in Excel formatted to show the rounded off result. To achieve a rounded off result in Word, you can either round the data off correctly in Excel, or apply a numeric picture switch to the Word MERGEFIELD. To do the latter: . select the Word MERGEFIELD and press Shift-F9. You should see something like- {MERGEFIELD ExcelData} . edit the Word MERGEFIELD to look like- {MERGEFIELD ExcelData \# 0.0} . press F9 . run your mailmerge. See Word's help file for more information on field formatting Cheers "ZGH" wrote in message ... I used a Excel file as mailmerge's data source.But the data,such as 2.4, in excel, changed to a long format,such as 2.39999999, in word document. I don't want these changes.Some suggestions? Thanks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail Merge Error - can't find data source | Mailmerge | |||
| Formatting field does not format all field data | Microsoft Word Help | |||
| Help! I'm getting error messages too much-can't open Resume Wizard | Microsoft Word Help | |||
| Specific Email Merge w/ Specific Attachements | Mailmerge | |||
| Preserve a macro-table's format when fetching data thro' merge pro | Tables | |||
Threaded Mode