Format Cell

[JTL9161]

I have the formula:

=A1&" / "&B1

The A1 cell is a number and the B1 cell is a calculated percentage, but my combined result in C1 is

9 / .053125

Is there a way to get it to show a percentage like: 9 / 53%

The B1 cell is already formatted to show the result as 53% but that does not translate over to C1.

Thank you,
James

 

[Fluff]

How about
=A1&" / "&TEXT(B1,"0%")