View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shams Shams is offline
external usenet poster
 
Posts: 47
Default 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.