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

"Brian" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| 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

Brian wrote:

> 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

="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 wrote:
> 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
>

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

Brian

Ken Puls wrote:
> ="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 wrote:
> > 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
> >