Prev: vioce in excel
Next: SUMIFS and Dates
From: Shams on 16 Feb 2010 17:00
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.
>
>
First  |  Prev  | 
Pages: 1 2
Prev: vioce in excel
Next: SUMIFS and Dates