Convert Decimal to Percent Within Text String

B

Brian

Hello everybody,

I have a text string in Excel that contains percentage values taken
from different cells. However, the text string reads the percentage
value and outputs it as a decimal:

Percent defects of 0.678276052493135, 0.674664937815204 and
0.57388331030011.

Here is the code:

="Percent defects of "&N2&", "&N3&" and "&N4&"." (Cells N2, N3 and N4
contain percentages)

I hope I'm not missing a very simple solution here.

Thanks!
Brian
 
N

Niek Otten

Hi Brian,

="Percent defects of "&TEXT(N2,"0.00%") etc

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello everybody,
|
| I have a text string in Excel that contains percentage values taken
| from different cells. However, the text string reads the percentage
| value and outputs it as a decimal:
|
| Percent defects of 0.678276052493135, 0.674664937815204 and
| 0.57388331030011.
|
| Here is the code:
|
| ="Percent defects of "&N2&", "&N3&" and "&N4&"." (Cells N2, N3 and N4
| contain percentages)
|
| I hope I'm not missing a very simple solution here.
|
| Thanks!
| Brian
|
 
P

Pete_UK

Try this, Brian:

="Percent defects of "&TEXT(N2,"0.0%")&", "&TEXT(N3,"0.0%")&" and
"&TEXT(N4,"0.0%")&"."

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel text formula trouble 1
Function to format a value into percent with no decimal 3
Bold items within text string 7
convert text to values 7
PLEASE HELP!!! I cant convert a cell to text for some reason. 1
Convert Number to Text String 3
Convert double to string with more then 9 decimal places 3
Formula percent complete excluding given text string 2

Top