ExcelBanter - Trouble with concatenation number format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Trouble with concatenation number format (https://www.excelbanter.com/excel-worksheet-functions/133180-re-trouble-concatenation-number-format.html)

Gary''s Student

Trouble with concatenation number format

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

All times are GMT +1. The time now is 12:36 AM.