Action:How do I change the number format within the concantenate function

try something like
="The rate is "&text($A$1,"0%")

"micoope" wrote:

> I have created a formula that uses the concantenate function that refers to a
> cell that is formatted as percentage. However, the cell that contains the
> formula shows the referred to cell as a decimal. The referred to cell is
> using a list and data validation. For example, cell A1 uses a list of the
> following number: 1%, 2%,....99%. Since data validation is used, a drop down
> list is created with all of these percentages. Cell B1 has the formula
> '=CONCANTENATE("The rate is "$A$1)' The result shown is 'The rate is 0.85'
> I want it to display 'The rate is 85%'
>
> Thanks.

It worked! Thanks.
/mc

"bj" wrote:

> try something like
> ="The rate is "&text($A$1,"0%")
>
> "micoope" wrote:
>
> > I have created a formula that uses the concantenate function that refers to a
> > cell that is formatted as percentage. However, the cell that contains the
> > formula shows the referred to cell as a decimal. The referred to cell is
> > using a list and data validation. For example, cell A1 uses a list of the
> > following number: 1%, 2%,....99%. Since data validation is used, a drop down
> > list is created with all of these percentages. Cell B1 has the formula
> > '=CONCANTENATE("The rate is "$A$1)' The result shown is 'The rate is 0.85'
> > I want it to display 'The rate is 85%'
> >
> > Thanks.

I have created a formula that uses the concantenate function that refers to a
cell that is formatted as percentage. However, the cell that contains the
formula shows the referred to cell as a decimal. The referred to cell is
using a list and data validation. For example, cell A1 uses a list of the
following number: 1%, 2%,....99%. Since data validation is used, a drop down
list is created with all of these percentages. Cell B1 has the formula
'=CONCANTENATE("The rate is "$A$1)' The result shown is 'The rate is 0.85'
I want it to display 'The rate is 85%'

Thanks.

try something like
="The rate is "&text($A$1,"0%")

"micoope" wrote:

> I have created a formula that uses the concantenate function that refers to a
> cell that is formatted as percentage. However, the cell that contains the
> formula shows the referred to cell as a decimal. The referred to cell is
> using a list and data validation. For example, cell A1 uses a list of the
> following number: 1%, 2%,....99%. Since data validation is used, a drop down
> list is created with all of these percentages. Cell B1 has the formula
> '=CONCANTENATE("The rate is "$A$1)' The result shown is 'The rate is 0.85'
> I want it to display 'The rate is 85%'
>
> Thanks.

It worked! Thanks.
/mc

"bj" wrote:

> try something like
> ="The rate is "&text($A$1,"0%")
>
> "micoope" wrote:
>
> > I have created a formula that uses the concantenate function that refers to a
> > cell that is formatted as percentage. However, the cell that contains the
> > formula shows the referred to cell as a decimal. The referred to cell is
> > using a list and data validation. For example, cell A1 uses a list of the
> > following number: 1%, 2%,....99%. Since data validation is used, a drop down
> > list is created with all of these percentages. Cell B1 has the formula
> > '=CONCANTENATE("The rate is "$A$1)' The result shown is 'The rate is 0.85'
> > I want it to display 'The rate is 85%'
> >
> > Thanks.