Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
data format error
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
data format error
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
data format error
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 |
#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 |
Reply |
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 |