Formatting Question with text Strings

[M3rlin]

I am creating a text string that will insert percentages from another cell as a summary. However, the percentages include several decimals over the 2 I prefer. Listed below is a formula I am using. Everything works fine except for the extra decimals.

Baltimore Sales Wins For WE 11-26-05.xls
	B	C	D	E	F	G	H	I	J
35	Store XXXX total store Same Store Sales were up 24.0937857375481 %
12-03

I have tried reformatting the source data, but to no avail. Any help would be greatly appreciated!

 

[NBVC]

Try

="Store "&A3&" total store Same Store Sales were up "&Round(D3*100,2)&" %"

 

[Von Pookie]

Maybe use TEXT(D3*100,"0.00%") instead?

 

[Andrew Poulsom]

You could use:

TEXT(D3,"0.00%")

in your concatenation formula.

 

[M3rlin]

Thanks NBVC! I tried yours and it worked! I will probably try the other suggestions to broaden my knowledge! Thanks again for the help everyone!