mail merge with excel - how do get only 2 decimal places after com

K

Kerstin

I merge the excel data into the word. I have one column that contains numbers
from a formular and should show 2 decimal places after the comma but in word
it shows 5 or 6. No matter how I format that field - I tried currency,
accounting ... no change!

The formular in the cell is =H68*167 - something I can change with the
formular so it only shows 2 places after the comma???

Please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
Excel does not accept text format! 0
Decimal places in mail merge 1
Windows 2016- Unable to do mail merge with my secondary email accounts 1
How can I stop Merged nos. from excel having 6-7 nos after decimal 5
Merging values into Word documents 7
How can I get a merge field in Word to display only 2 decimal plac 1
Limit the number of decimal places shown when I merge Excel-Word 1

Top