Concatenating Currency and Percent
in [General]
|
Prev: vioce in excel
Next: SUMIFS and Dates
From: Shams on 16 Feb 2010 16:42 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.
From: pmartglass on 16 Feb 2010 16:50 "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. > >
From: pmartglass on 16 Feb 2010 16:53 =TEXT(A1,"$#,###.00") & " or " & TEXT(B1,"#.##%") Hope this works for you "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. > >
From: Shams on 16 Feb 2010 16:55 Hi, I didn't see any reply text in your message!! "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. > >
From: מיכאל (מיקי) אבידן on 16 Feb 2010 16:56
Maybe, something like this: =TEXT(A1,"$ #")&" or: "&TEXT(B1,"#.## %") Micky "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. > > |