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