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

--
Gary''s Student
gsnu200708


"FJ" wrote:

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.