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.

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.

Method 1: use custom format such as 0.00 "%"
Method 2; what ever you formula is use (your-formula)/100, then you can use
the percentage format
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Sarrous" wrote in message
...
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.

"Bernard Liengme" wrote:
Method 2; what ever you formula is use (your-formula)/100,
then you can use the percentage format

Or simply (yourFormula)%. "%" is a unary operator in Excel.


----- original message -----

"Bernard Liengme" wrote in message ...
Method 1: use custom format such as 0.00 "%"
Method 2; what ever you formula is use (your-formula)/100, then you can use
the percentage format
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Sarrous" wrote in message
...
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.

"Sarrous" wrote:
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.

Why not? The most efficient and effective way to get assistance is to provide concrete examples, complete with formulas that you already have. We are not mindreaders.


Is there a way to add the symbol to the end of the answer in the
same cell.

Other respondents have ass-u-me-d that you currently compute, e.g., the "percentage" 50% as the number 50 instead of the number 0.5. It's a good guess.

But if that's the case, a question might be: why do you do it that way? Would you be open to suggestions that would permit you to use the Percentage format? I suspect that will be better for you in the long run.

I cannot go any further with that because I have no idea how you are performing the calcuations. The devil's in the details.