Trouble with concatenation number format

F

FJ

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.
 
F

FJ

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


KL said:
=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/profile=AB32F8EE-8ED3-4AB9-ADDA-9E6C73C09A36


FJ said:
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.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
concatenate 2
Concatenation Setback 4
format/concatenation 1
Excel - Wich Function should I use? 1
Concatenate 3
Setting column width in a table with a macro is not working 0
concatenate contents of cells whose contents resemble cell referem 3

Top