Solved: Quick Concatenate Question (formatting)

[Saladsamurai]

In a cell I want to show the Heading and a percentage that links to a cell. So I have the following in the formula bar


="Cold Diff Tiles Only" & " (" & ($E$33/$B$33) & ")"

which results in: Cold Diff Tiles Only (0.291642314436002)

I want it to show: Cold Diff Tiles Only (29%)

So, what do I need to add to

="Cold Diff Tiles Only" & " (" & ($E$33/$B$33) & ")"
in order to include the 'percentage with 0 decimal places showing' format?

Thanks so much!

[stanleydgrom]

Saladsamurai,

Try:
="Cold Diff Tiles Only (" & TEXT($E$33/$B$33,"0%") & ")"


Have a great day,
Stan

[georgiboy]

Saladsamurai,

Try:
="Cold Diff Tiles Only (" & TEXT($E$33/$B$33,"0%") & ")"


Have a great day,
Stan

I like that, i would have used...

="Cold Diff Tiles Only" & " (" &ROUND( $E$33/$B$33*100,0) & "%" & ")"

[Saladsamurai]

Nice! Thanks guys!