Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
How do I attach an excel document to a word one for mail merge? | Excel Discussion (Misc queries) | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
Mail merge to word | Excel Discussion (Misc queries) | |||
in mail merge how do i convert currency from excel to word | Excel Discussion (Misc queries) |