• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mail merge using excel

Abbas

Abbas

New Member
I have made a certificate in Word which takes values from Excel database.

Now there is a column which gives me percentage. I want only 2 place after decimal and I did this in Excel using "decrease decimal" button. But when Word fetches these values by mail merge, it gives several places after decimal. How to make it take only 2 places after decimal?

Another question I have is: I want to apply conditional formatting to all cells having values other than the tolerance ±5%. I am doing it by making 2 columns one with -5, other with +5 and putting two conditions: one for all values less than -5 and other for all values greater that +5.
Is it possible to put just ±5 in one column and use one condition. I keep changing the tolerance to different values so I don't want to include it in the formula.

Please help.
 
Hi Abbas ,

Regarding your second question , I am not sure I have understood you.

Let us assume your tolerance figure is in cell D1 ; D1 can therefore have a value of 5% or 0.05

Now , select your range of data , say C5 through F17 , and enter the following CF formula :

=AND(C5<=-$D$1,C5>=$D$1)

This will colour all cells which have values outside the tolerance figure.

Narayan
 
Just briefing Narayan's word.
In word..mail merge..

Select the filed.. Press Alt + F9,
It will now looks something like {MERGEFIELD Column_Name}
change this to to {MERGEFIELD Column_Name\#0.00} or the desired Display Format, like in Excel.
Now again select the Field and press ALT + F9 to exit Program Mode of the field.

and for second query..
try googling ABS function also...
 
There is another way to your first question:
In your word file, go to File-->Options-->Advanced--> Scroll all the way down to General and check "Confirm file format conversion open"
 
You must log in or register to reply here.
Back
Top