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 / April 2004

Tip: Looking for answers? Try searching our database.

DECIMAL POINTS & MERGING

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Telita - 22 Apr 2004 12:44 GMT
When I merge my Excel spreadsheet into a Word document
all the amounts come out as shown in the formula bar in
Excel and not as shown in the actual cell in the sheet,
e.g. in the formula bar there are no decimal points -
2.000111111 and in the cell it shows up as follows 2.0

Many thanks
T
macropod - 22 Apr 2004 13:12 GMT
Hi Telita,

You'll probably find that the Excel data is actually the same as what Word's
showing, except that Excel is formatted to show only 2 decimal places.

To get the same result in Word, add a numeric picture switch to the
mailmerge field, like '\# 0.00', so that your field looks something like:

{MEGEFIELD Data \# 0.00} or {MEGEFIELD Data \# 0.00 \* Mergeformat}

Cheers

> When I merge my Excel spreadsheet into a Word document
> all the amounts come out as shown in the formula bar in
[quoted text clipped - 4 lines]
> Many thanks
> T
Graham Mayor - 22 Apr 2004 13:46 GMT
Word displays the raw data from Excel and is now expected to provide the
formatting - see http://www.gmayor.com/formatting_word_fields.htm

Signature

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

  Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> When I merge my Excel spreadsheet into a Word document
> all the amounts come out as shown in the formula bar in
[quoted text clipped - 4 lines]
> Many thanks
> T
Telita - 30 Apr 2004 15:47 GMT
Just to say a BIG THANK YOU to you both.  It worked
brilliantly and I have saved it never to forget it!!

T
>-----Original Message-----
>When I merge my Excel spreadsheet into a Word document
[quoted text clipped - 7 lines]
>
>.

Rate this thread:






 
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.