Formatting a number inside a formula

Sorry all but the title probably doesnt really explain the question properly

What id like to do to limit the amount of decimals in my answer

below is my formula.

="Overall Comex FPN's running at "&E29&" average based on above figures"

E29 = 2.8447477557
but shows as 2.84% in the cell

and this is what is comes out as

="Overall Comex FPN's running at 2.8447477557 average based on above figures"

id like it to just say

="Overall Comex FPN's running at 2.84% average based on above figures"

any help would be greatly appriciated.

Perhaps

="Overall Comex FPN's running at "&round(E29,2)&"% average based on above figures"

Perfect thank you

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save