LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Alejandra
 
Posts: n/a
Default Mail Merge with Word


Hi,

I am trying to insert information (figures) contained in an Excel
worksheet into a Word letter (in the example I have 100 clients with
their monthy bill information and have to send out letter to every one
of them with his particular billing information). I did it with the
Word command Mail Merge withing TOOLS, inserted the fields and worked
pretty well. The only problem is that the figures appear in the Word
letter with 8 decimals, which of course looks very bad. I could not
manage to delete the decimals in the Excel spreadsheet, they are always
there, even if you format the cell, as a number with cero decimals or if
you customize the cell with cero decimals. They don't disappear.(This
happens in Excel 2000 and 2003)

What can I do to insert figures without decimals into a Word letter?
I hope you can help me.:)
Alejandra


--
Alejandra
------------------------------------------------------------------------
Alejandra's Profile: http://www.excelforum.com/member.php...o&userid=31933
View this thread: http://www.excelforum.com/showthread...hreadid=516590

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Difficult for me, probably basic to you onlyjohn Excel Worksheet Functions 1 February 3rd 06 05:14 PM
How do I attach an excel document to a word one for mail merge? Ruth Excel Discussion (Misc queries) 1 January 6th 06 10:29 PM
Link excel and word in mail merge without losing your data source? angie Excel Discussion (Misc queries) 5 July 1st 05 06:29 PM
Mail merge to word James42 Excel Discussion (Misc queries) 0 June 10th 05 01:32 AM
in mail merge how do i convert currency from excel to word amedeo Excel Discussion (Misc queries) 1 May 5th 05 10:34 PM


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"