Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel data to word, keeps including all decimals on number
I have a spread**** with a price of e.i 13‚¬.
Next colum have a calculated field deducting 5% and rounded to 2 decimals using ROUND. Then I even copy the fields and paste them into another cell only inserting values (no format). When importing for labelprint in word, I keep getting all decimals instead of only 2. Why is that and what can I do? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel data to word, keeps including all decimals on number
Debra Dalgleish posted this to a similar question:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. Maybe it'll be easier to understand. Henrik Notlev wrote: I have a spread**** with a price of e.i 13‚¬. Next colum have a calculated field deducting 5% and rounded to 2 decimals using ROUND. Then I even copy the fields and paste them into another cell only inserting values (no format). When importing for labelprint in word, I keep getting all decimals instead of only 2. Why is that and what can I do? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel data to word, keeps including all decimals on number
The Problem is solved.
I got a link to an article from a Microsoft girl. The article suggested that I used ALT+F9 on the Mergefield in Word and added \#.###,## to the Fieldcodes. That solved the problem. Thanks to everyone taking time to try to help me. This was my first visit at MS Discussion groups, but not my last. "Henrik Notlev" wrote: I have a spread**** with a price of e.i 13‚¬. Next colum have a calculated field deducting 5% and rounded to 2 decimals using ROUND. Then I even copy the fields and paste them into another cell only inserting values (no format). When importing for labelprint in word, I keep getting all decimals instead of only 2. Why is that and what can I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Copy a word doc to excel and hyperlink data between the 2. | Charts and Charting in Excel | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Merging excel data into word | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |