Saladsamurai
10-06-2009, 05:42 AM
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!
="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!