How do I change the number format within the concantenate function
 

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.