adding a % symbol to the end of data

  • Thread starter Thread starter Sarrous
  • Start date Start date
S

Sarrous

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 Liengme said:
Method 2; what ever you formula is use (your-formula)/100,
then you can use the percentage format
Click to expand...

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


----- original message -----
 
Sarrous said:
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.
Click to expand...

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.
Click to expand...

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.
 
Back
Top