Convert Number to Percentage

How would it be? If you could make the traffic in front of your car disappear at the press of a button? Well we haven’t advanced so much but what I can give you at the press of a button is as follows:

While working on huge reports we usually kill most of our time searching for necessary options. So, here is a nice tip which reduces most of your time and I believe you will definitely post the comment on how much time you have saved by using this tip.

Here we go:

...

The table here has 'Company name' and 'Profit %', assume this is for 1st quarter of 2013. In 'Profit %' column, the values are in digits but should be in percentage.

You understood right.

What I mean to say is the number in the 'Profit %' column should have percentage (%) symbol next to each number but it is in nude format, Oh! I am sorry it is in number format.

If you want to add % symbol next to the number, we can edit the cell and add % symbol by using SHIFT + 5 (number key).

What if we have thousands of cells in this format?

Do we have any other mode to convert from number to percentage. Yes, Here we go.

First use helper column/cell.

Type 100.

Select the data which needs to convert from number to percentage

Then, copy the cell contain 100

Use PasteSpecial option and

Select 'Divide' below the Operation Menu

Click OK

Now the data will reflects in decimals. Use CTRL + SHIFT + 5 (numeric key). This will result in the number being converted to percentage.

See ! Didn’t I say this will save your time?

This will definitely reduce lot of time using this method.

Did you find this interesting. Do you have any tips like above. Please do share with me to publish in ongoing posts. Let me learn and let others learn too. Share your comments, ideas, achievements in the below comments section.