how to keep the same format

[Tody03]

I want to combine in one cell two numbers with different formats. How to maintain the percentage format

Command Result Desired display -6% 80 =B2&" "&A2 80 -0.0584795321637427 80 -6% <colgroup><col span="2"><col><col><col></colgroup><tbody> </tbody>

<colgroup><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>

thanks

 

[FormR]

Hi, you can try:

=B2&" "&TEXT(A2,"0%")

 

[Tody03]

So quickly and so good!!!!
By the way, it is working.
thanks
tody

 

[Tody03]

I need your help again.
i tried to install your code into my macro and i got errors. can you help me to correct the the syntax

Range("G2").Select
ActiveCell.FormulaR1C1 = "=Rc[-3]&"",""&text(Rc[-4],0%)&"",""
Thanks

 

[FormR]

i tried to install your code into my macro and i got errors. can you help me to correct the the syntax

Hi, the easiest way to get the correct syntax for formulas is to record a macro whilst you manually enter it into the cell.

The recorder gives..

Range("G2").Select
ActiveCell.FormulaR1C1 = "=RC[-1]&"" ""&TEXT(RC[-2],""0%"")"

Which can then be simplified to..

Range("G2").FormulaR1C1 = "=RC[-1]&"" ""&TEXT(RC[-2],""0%"")"

 

[Tody03]

Hello
I was waiting for you the whole morning.
It is working now
Thanks again
Tody