Text formatting

[PE]

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]

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

=text(b4,"##%")

hope this helps
Regards from Brazil
Marcelo

"PE" escreveu:

 

[CLR]

Maybe this.........

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

Vaya con Dios,
Chuck, CABGx3