data format error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ZGH - 08 Dec 2005 21:13 GMT

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 to this Message

macropod - 09 Dec 2005 08:12 GMT

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

> 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 to this Message

Graham Mayor - 09 Dec 2005 10:32 GMT

See also http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi,
>
[quoted text clipped - 19 lines]
>> document. I don't want these changes.Some suggestions?
>> Thanks

Reply to this Message

ZGH - 09 Dec 2005 23:31 GMT

Thanks, it works.

> See also http://www.gmayor.com/formatting_word_fields.htm
>
[quoted text clipped - 21 lines]
>>> document. I don't want these changes.Some suggestions?
>>> Thanks

Reply to this Message