Convert Decimal to Percent Within Text String

  • Thread starter Thread starter Brian
  • Start date Start date
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
 
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
|
 
Try this, Brian:

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

Hope this helps.

Pete
 
Back
Top