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

Mail Merge - displaying a conditional number of decimals 5
Can I make a formula that always uses the latest wksht in Book2? 2
Connecting Worksheets using and "if" "then" formula 1
Mail Merge - Thousand separators & Decimals 1
Mail Merge - Thousand separator and decimals 1
Adding data only if adjacent to cell labeled "male"/"female" 1
using a table as reference in creating formula 5
Producing quarterly figures? 2

Top