Convert Decimal to Percent Within Text String

[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

 

[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
|

 

[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

 

[Ken Puls]

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

HTH

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

 

[Brian]

Thank you to everybody who contributed to this excellent team effort!

Brian