Thread: Merging Excel data to word, keeps including all decimals on number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Henrik Notlev
 
Posts: n/a
Default 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?

Reply With QuoteReply With Quote