Strange number field behaviour

[kilkerr1]

Hello all

I'm merging records from an Excel spreadsheet to a Word document as a
bunch of labels. This is all fine. One of the data fields is a
number. When I merge the spreadsheet data with the Word document it
shows the numbers on the screen as I want them printed. So, the number
field may have the number '40' shown on the label on the screen.

However, when I print the label out, the number '40' is printed as
'40.00', with the decimal point, rather than just the two digit number.
So basically the print out isn't what's shown on the screen at all.
Even in print preview it just shows the two-digit number, but still
prints out the number with the decimal point and two zeros after it.

I really need just the two-digit number printed. I'm sure this is a
simple thing - please help!

Thanks.

 

[Peter Jamieson]

Which version of Word/Excel?

Are the numbers in your spreadsheet formatted as "Currency" ? If so, try
changing the formatting.

Try changing a mergefield such as

{ MERGEFIELD mynumber }

to

{ MERGEFIELD mynumber \#0 }

However, if you want to get the data as displayed in Excel you probably need
to change the way Word connects to Excel to DDE. You probably only need to
do that in Word 2002 or later - check Word Tools|Options|General|'Confirm
conversions at open', go through the connection process again, and select
the DDE option when offered.