Concatenating Currency and Percent
 

I am trying to concatenate two cells which are in 2 different formats:

Cell A1: $5,000,000
Cell B1: 16.90%

So, in Cell C1, I am trying to say the following: $5,000,000 or 16.9%

I am trying to do a concatenation..however the percentage is turning into
decimals and I am losing the currency format as well

What would be the best way of dealing with this..Thanks

Regards,
Shams.

Concatenating Currency and Percent
 

"Shams" wrote:

I am trying to concatenate two cells which are in 2 different formats:

Cell A1: $5,000,000
Cell B1: 16.90%

So, in Cell C1, I am trying to say the following: $5,000,000 or 16.9%

I am trying to do a concatenation..however the percentage is turning into
decimals and I am losing the currency format as well

What would be the best way of dealing with this..Thanks

Regards,
Shams.

Concatenating Currency and Percent
 

=TEXT(A1,"$#,###.00") & " or " & TEXT(B1,"#.##%")

Hope this works for you



"Shams" wrote:

I am trying to concatenate two cells which are in 2 different formats:

Cell A1: $5,000,000
Cell B1: 16.90%

So, in Cell C1, I am trying to say the following: $5,000,000 or 16.9%

I am trying to do a concatenation..however the percentage is turning into
decimals and I am losing the currency format as well

What would be the best way of dealing with this..Thanks

Regards,
Shams.

Concatenating Currency and Percent
 

Hi,
I didn't see any reply text in your message!!

"Shams" wrote:

I am trying to concatenate two cells which are in 2 different formats:

Cell A1: $5,000,000
Cell B1: 16.90%

So, in Cell C1, I am trying to say the following: $5,000,000 or 16.9%

I am trying to do a concatenation..however the percentage is turning into
decimals and I am losing the currency format as well

What would be the best way of dealing with this..Thanks

Regards,
Shams.

Concatenating Currency and Percent
 

Maybe, something like this:
=TEXT(A1,"$ #")&" or: "&TEXT(B1,"#.## %")
Micky


"Shams" wrote:

I am trying to concatenate two cells which are in 2 different formats:

Cell A1: $5,000,000
Cell B1: 16.90%

So, in Cell C1, I am trying to say the following: $5,000,000 or 16.9%

I am trying to do a concatenation..however the percentage is turning into
decimals and I am losing the currency format as well

What would be the best way of dealing with this..Thanks

Regards,
Shams.

Concatenating Currency and Percent
 

Hi Mickey and pmartglass,
Thanks to both of you for the tip..yes the formula works perfectly!!

"Shams" wrote:

I am trying to concatenate two cells which are in 2 different formats:

Cell A1: $5,000,000
Cell B1: 16.90%

So, in Cell C1, I am trying to say the following: $5,000,000 or 16.9%

I am trying to do a concatenation..however the percentage is turning into
decimals and I am losing the currency format as well

What would be the best way of dealing with this..Thanks

Regards,
Shams.