Using formula-generated figures in excel in mail-merging

B

bluestar

I am trying to create a database that contains 1 column of fixed numbers with
2 decimals, when the adjacent column containing formula-generated figures
also at 2 decimals. But when I try to transfer those formula-generated
figures into a letter mail-merge, those figures are carried out to up to 16
places. Consequently I have to manually delete those extra 14 places in each
and every letter to be mailed out. Is there any way I can prevent this?
 
L

Luke M

Encase your formula within the ROUND function.
=ROUND(YourFormulaHere,2)

Now you truly only have 2 decimals (not just displaying only two decimals)
so you can copy it itno your mail-merge just fine.
 

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

Can I make a formula that always uses the latest wksht in Book2? 2
Mail Merge - Thousand separators & Decimals 0
Mail Merge - Thousand separator and decimals 1
formula to add dates. 8
Mail Merge with Excel and Word 3
using value in 3rd column to decide if outcome is positive or negative 15
Multi add, in array of data 2
Mail Merge in Word using Excel Spreadsheet 1

Top