Thread: Text formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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