Concatenating Currency and Percent

  • Thread starter Thread starter Shams
  • Start date Start date
S

Shams

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.
 
Shams said:
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.
Click to expand...
 
Maybe, something like this:
=TEXT(A1,"$ #")&" or: "&TEXT(B1,"#.## %")
Micky
 
Hi Mickey and pmartglass,
Thanks to both of you for the tip..yes the formula works perfectly!!
 
Back
Top