Hi,

I have created a formula with "concatenate", that includes string and
other formulas in it.

=CONCATENATE("*Of these, ",VLOOKUP($A$2,Terms.xls!$A$6:$D$23,3),"
(",(VLOOKUP($A$2,Terms.xls!$A$6:$D$23,3)/C12)*100,"%)"," have been
employed for more than 2 years, compared with
",VLOOKUP("total",Terms.xls!$A$6:$D$23,3),"
(",(VLOOKUP("total",Terms.xls!$A$6:$D$23,3)/E12)*100,"%),"," at the
department.")

The problem is that the % I get gives me for example : 20.7860052364%.
How do I format my % so that I get only "20%" or "20.8%".

thanks!


--
Outapin
------------------------------------------------------------------------
Outapin's Profile: http://www.excelforum.com/member.php...o&userid=29278
View this thread: http://www.excelforum.com/showthread...hreadid=489964