% without % sign

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I am trying to calculate percentages of five columns of
data without the percent sign.
How would I do this?

Cell Format % returns 6.5%
Objective % - > 6.5

Thank you.
Alex
 
Hi,

If the data is in cell B3 and C3, then enter the formula
as =C3/B3*100 in cell D3. Hope this answers your question

Regards,

Ashish Mathur
 
I already have all the data calculated as =c3/b3 and I was
wondering if you could change the cell formating or apply
a formula to a block of cells. Thanks for your easy
answer, but it was not the answer to my question.
 
Hi,

Sorry for misunderstanding your question

Do the following

1. Type 100 somewhere outside the range of data
2. Copy this value
3. Select the range which contains the formula
3. Go to Edit > Paste Special > Select Multiply

Hope this is useful

Regards,

Ashish Mathur
Excel - MVP
 
Thank you very much.
-----Original Message-----
Hi,

Sorry for misunderstanding your question

Do the following

1. Type 100 somewhere outside the range of data
2. Copy this value
3. Select the range which contains the formula
3. Go to Edit > Paste Special > Select Multiply

Hope this is useful

Regards,

Ashish Mathur
Excel - MVP




.
Click to expand...
 
Beware, however, that the proposed solution changes your data by multiplying it by 100. It's no
different than changing your formulas to =C3/B3*100.
 
Back
Top