ExcelBanter - Text formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text formatting (https://www.excelbanter.com/excel-discussion-misc-queries/92606-text-formatting.html)

Text formatting

I want to display a percentage value in a cell as text in another cell. Not
sure what I need to do format_text bit of the formula:

=TEXT(cellref, "...........")

Would appreciate your help.

Al

Marcelo

Text formatting

imagine that you have 10% on the cell B4, the formula could be:

=text(b4,"##%")

hope this helps
Regards from Brazil
Marcelo

"PE" escreveu:

I want to display a percentage value in a cell as text in another cell. Not
sure what I need to do format_text bit of the formula:

=TEXT(cellref, "...........")

Would appreciate your help.

Al

CLR

Text formatting

Maybe this.........

=TEXT(A1*100,"##")&" Percent"

Vaya con Dios,
Chuck, CABGx3

"PE" wrote:

I want to display a percentage value in a cell as text in another cell. Not
sure what I need to do format_text bit of the formula:

=TEXT(cellref, "...........")

Would appreciate your help.

Al

All times are GMT +1. The time now is 03:14 PM.