% without % sign

[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

 

[Ashish Mathur]

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

 

[alex]

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.

 

[Ashish Mathur]

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

 

[Alex]

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




.

 

[Myrna Larson]

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.