Hi, I am having trouble with a concatenation formula. I have $1,000,000 in
cell A1 and 75% in cell B1. Once the numbers are concatenated I want them
appear in cell C1 exactly as they are. The problem is that when I
concatenate them the result is as follows:

1000000, 0.75.

How can I format them to appear with the $ and % signs? So far I have:

=CONCATENATE(A1,", ",B1)

Thanks in advance for any help.

=TEXT(A1,"$#,##0")&","&TEXT(B1,"0.0%")

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/pr...A-9E6C73C09A36


"FJ" wrote in message ...
Hi, I am having trouble with a concatenation formula. I have $1,000,000 in
cell A1 and 75% in cell B1. Once the numbers are concatenated I want them
appear in cell C1 exactly as they are. The problem is that when I
concatenate them the result is as follows:

1000000, 0.75.

How can I format them to appear with the $ and % signs? So far I have:

=CONCATENATE(A1,", ",B1)

Thanks in advance for any help.

Hi, thanks for your response. Your formula worked perfectly. :)


"KL" wrote:

=TEXT(A1,"$#,##0")&","&TEXT(B1,"0.0%")

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/pr...A-9E6C73C09A36


"FJ" wrote in message ...
Hi, I am having trouble with a concatenation formula. I have $1,000,000 in
cell A1 and 75% in cell B1. Once the numbers are concatenated I want them
appear in cell C1 exactly as they are. The problem is that when I
concatenate them the result is as follows:

1000000, 0.75.

How can I format them to appear with the $ and % signs? So far I have:

=CONCATENATE(A1,", ",B1)

Thanks in advance for any help.