Converting number in to %

Originally Posted by mangesh

Hi,

I have an excel sheet in which I have lots of numbers. I would like to have percentage sign after these numbers(%). I tried formating cell as percentage but its not giving the desired result.

for example.

In Cell A1 I have 88.25 and I would like to convert it as 88.25%. When I am formating it as percentage its giving me 8825.00%

Hi mangesh,

Format cell, by clicking on % icon, then enter 88.25 and format to 2 decimal places

oldchippy

Originally Posted by oldchippy

Hi mangesh,

Format cell, by clicking on % icon, then enter 88.25 and format to 2 decimal places

oldchippy

The way you described still yields the same results (the example will still yield 8825%)

I'm not sure of a simple one or two step solution that will solve your problem, mangesh, but I do know of a complicated way that will work.

First, create a new temporary worksheet. Select all of the first worksheet, and paste it all to the new worksheet. Goto the new temporary worksheet and in one of the cells that you want to change, add the formulia (example Cell C3)

Please Login or Register  to view this content.

Copy that cell and paste it to all of the cells where there are the percentages you want.

In the new temporary worksheet, select all, then goto the original worksheet and paste special and select values.

THIS WILL REMOVE ALL FORMULIAS IN YOUR CURRENT WORKSHEET.

If you have formulias on this first worksheet then you will need to copy and paste only the select cells containing the numbers you wish to convert to percentages, (hopfully they are all within only a few rows, colums, or easy to select blocks for convience.)

Originally Posted by Libertine

The way you described still yields the same results (the example will still yield 8825%)

I'm not sure of a simple one or two step solution that will solve your problem, mangesh, but I do know of a complicated way that will work.

First, create a new temporary worksheet. Select all of the first worksheet, and paste it all to the new worksheet. Goto the new temporary worksheet and in one of the cells that you want to change, add the formulia (example Cell C3)

Please Login or Register  to view this content.

Copy that cell and paste it to all of the cells where there are the percentages you want.

In the new temporary worksheet, select all, then goto the original worksheet and paste special and select values.

THIS WILL REMOVE ALL FORMULIAS IN YOUR CURRENT WORKSHEET.

If you have formulias on this first worksheet then you will need to copy and paste only the select cells containing the numbers you wish to convert to percentages, (hopfully they are all within only a few rows, colums, or easy to select blocks for convience.)

Hi Libertine,

The way you described still yields the same results (the example will still yield 8825%)

You haven't done it the way I described it

Format cell, by clicking on % icon, then enter 88.25 and format to 2 decimal places

Originally Posted by oldchippy

Hi Libertine,

The way you described still yields the same results (the example will still yield 8825%)

You haven't done it the way I described it

Format cell, by clicking on % icon, then enter 88.25 and format to 2 decimal places

Ahh, I see what you mean now. You are correct, however you are recomending re-entering all the data.

Originally Posted by mangesh

I have an excel sheet in which I have lots of numbers.

I am assuming that mangesh has existing data, and a lot of it. More than would be practical to re-enter (hundreds or thousands of cells.)

...but we all know what happens when one assumes. *wink*

Originally Posted by mangesh

Hi,

I have an excel sheet in which I have lots of numbers. I would like to have percentage sign after these numbers(%). I tried formating cell as percentage but its not giving the desired result.

for example.

In Cell A1 I have 88.25 and I would like to convert it as 88.25%. When I am formating it as percentage its giving me 8825.00%

Hello again,

If you're still following this conversation, between me and Limbertine, another quick way is to put 1% into an empty cell, copy it, then select all the cells with your numbers in, right click select Paste Special and multiply.

Then format all the cells to 2 decimal places.

oldchippy

Originally Posted by oldchippy

Hello again,

If you're still following this conversation, between me and Limbertine, another quick way is to put 1% into an empty cell, copy it, then select all the cells with your numbers in, right click select Paste Special and multiply.

Then format all the cells to 2 decimal places.

oldchippy

Ahh, THAT is how you get the paste special math functions to work! I never understood them until I read your post and played with it. I like that way a LOT better. It is much simpler and quicker.

Good find.