View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default adding a % symbol to the end of data

Use 0"%" custom format code!

Regards,
Stefi

€˛Sarrous€¯ ezt Ć*rta:

I have a formula in a cell that takes data from others and calculates the
percentage.
Because of the way it is doe I cant make the cell a percentages format cell.
Is there a way to add the symbol to the end of the answer in the same cell.
I'm sure I have done this in the past but cant remember the format.

Many thanks.