Fraction to Percentage? Ex: 10/15 becomes 67 or 67%

[ryanunser]

Hi, I would like to be able to enter a fraction into a cell and have it automatically converted into a percentage.

For example, if I type 10/15 I would like that automatically changed into 67 or 67%

I apologize if this is overly simple, but I've looked around quite a bit and it doesn't seem as obvious as I think it should be...

Thanks!!
Ryan

[icestationzbra]

change the cell format to percentage...

[ryanunser]

change the cell format to percentage...

If I change the format to percentage with 2 decimal places, when I input 10/15 it displays as 0.67%, when the value I need is 67 or 67%.

[Russell Dawson]

=ROUND(10/15,2) format as percentage with 2 decimal places

[kassieK]

=ROUND(10*100/15,0), entered into a cell formatted as General, will give you 67%

[ryanunser]

I appreciate the replies, is there a way I can set a whole column to have the fractions converted automatically, though, as I enter them? I'm trying to avoid sitting here with a calculator entering each fraction to get a percentage before I type it in, when it really seems like something the computer should be doing for me... I've got lots and lots of cells that I need this to happen in, so typing a formula into each individual one would end up adding more time to the task.

[icestationzbra]

if you want the entire column of A to have the ability to convert any fraction into a percentage, do the following:

hover your mouse pointer over column label A and then click on it. when the entire column is highlighted, right-click on the highlighted portion, and select Format Cells. select Percentage and decrease Decimal Places to 0. no need to enter any formula in the entire column...

[ryanunser]

if you want the entire column of A to have the ability to convert any fraction into a percentage, do the following:

hover your mouse pointer over column label A and then click on it. when the entire column is highlighted, right-click on the highlighted portion, and select Format Cells. select Percentage and decrease Decimal Places to 0. no need to enter any formula in the entire column...

That's still not quite doing it An input of 10/15 gets converted to "1%", an input of 1/4 gets converted to "0%"...

Thanks though!

[icestationzbra]

:-) somehow when i am doing it on my computer here, it does exactly what i mentioned! let me check...

EDIT:

are you putting 10/15 without a '=' sign in front of it???

that's once you would get the problem you are facing...

[ryanunser]

:-) somehow when i am doing it on my computer here, it does exactly what i mentioned! let me check...

EDIT:

are you putting 10/15 without a '=' sign in front of it???

that's once you would get the problem you are facing...

That did it!!

Thanks so much!

[icestationzbra]

good to know, ryanunser.

for housekeeping purposes, please:

Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.