Concatenating Currency and Percent

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

pmartglass

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

מיכ×ל (מיקי) ×בידן

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

Shams

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

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

Top