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

[TABLE="width: 671"]
<colgroup><col span="2"><col span="2"><col></colgroup><tbody>[TR]
[TD][TABLE="width: 724"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Command[/TD]
[TD="align: left"]Result [/TD]
[TD="align: left"]Desired display [/TD]
[/TR]
[TR]
[TD]-6%[/TD]
[TD]80[/TD]
[TD="align: left"]=B2&" "&A2[/TD]
[TD="align: left"]80 -0.0584795321637427[/TD]
[TD="align: left"]80 -6%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]

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