Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) | |||
Customer Number Format | Excel Worksheet Functions | |||
how to change the h:mm format to number? | Excel Worksheet Functions |