Concatenating two number types into a cell

[doug firr]

I have done some analysis and am now preparing to present the results in a table.

I have a formula in a cell that looks like this: (E15+E16)&" "&"("&TEXT(E17,"0.00%")&")"

The results from this are a cell that looks like this: 670 (1.96%)

Being a little pedantic here but is there a way to edit the text formula so that it is all in italics like this: 670 (1.96%) ?

Also, see how I added the brackets using the concat operator &. Wonder if there's a neater way by integrating it into the text formula?

 

[steve the fish]

You could do this:

=(E15+E16)&TEXT(E17," (0.00%)")

 

[steve the fish]

Pretty sure you cant italicise unless you use VBA route

 

[doug firr]

I suspected that RE italics. Thanks for the tip

 

[doug firr]

Actually, would it be possible to change the size of the text in the text formula instead without VBA?