Cell to Display Text and Number display as Percentage

[binaryfingers]

HI

I would like to have a cell show a text word and a percentage together, however I am having trouble with the formatting.

Heres the scenario.

In B1 I have the text XBX
In B24 I have the percentage 4.5%

In A1 I would like to have the two joined together to get the following result

XBX 4.5%

Using the below joining I get the following result

=B1&" "&B24

XBX 0.0446

Can you please help provide a solution that will enable the desired result?

Thanks,

 

[Sweenster]

Hi,

This should do it....
=B1&" "& TEXT(B24,"#.##%")

Regards

 

[binaryfingers]

Hi Sweenster

I tried the Text command, but missed the vital #.## and just put "%"

thanks for your help

 

[macropod]

Hi binaryfingers,

You might find it preferable to use "0.00%" instead of "#.##". Otherwise leading/trailing 0s will be chopped off and you could even end up with just a '.' if the result is 0.

Cheers

[MS MVP - Word]