this is just a formula, i used values in h3 and i3

=H3 &" " & TEXT(I3,"##.0%")

--


Gary


"Roger on Excel" wrote in message
...
I want to transpose two cells into one whereby I have a text vaue "text" and
a percentage - eg 50%. In the adjacent cell i want to produce text&" "&50%,
to come out as text 50%. However but it comes out as text 0.5

Is there a way to make excel display exactly what i want rather than it
converting the percentage number into a decimal?

Thanks,

Roger