Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

Strange number field behaviour

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kilkerr1 - 01 Dec 2003 11:38 GMT
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 - 01 Dec 2003 13:33 GMT
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.

--
Peter Jamieson - Word MVP

> Hello all
>
[quoted text clipped - 16 lines]
>
> ------------------------------------------------
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.