I have spent most of today throwing data around in MS Excel.

One of the things that I have had to do is to convert percentages into real numbers.

In excel percentages are stored as fractions, for example 50% is stored as 0.5, 75% as 0.75 etc.

I am trying to chart these figures in Business Objects Xcelsius but the y-axis labels are just showing 0 to 0 hence why i need to convert my numbers.

I have just found a really easy way to do this.

- In the target cells, enter the value 100 in each cell.
- Copy the source cells
- Select “Paste Special” using the options “Values” and “Multiply”

This takes the source value 0.75 multiplies it by 100 and stores the result 75 !

I have used pase special – values often but I have never seen the need for the multiply option until now !

You may want to check out some of my other Excel related posts here.

*Related*

Hy, Dude!

You helped me a lot with this post. I tried to figure out the conversion from numbers to percent without getting my numbers multiplied with 100. Thanks a lot!

Thank you so much! You’ve helped me a lot!

Ross, thanks so much for providing this clean solution!

Good tip, sure saved me some time

A great help! and quick way to work with

thanks

Thanks so much! You really saved my life — or, at least, a ton of time!

Thanks, I forgot this and finally found on ur blog….

very useful, thanks!!!

if it wasn’t b’se you saved me i would not make it, thanks

wonderful, something I’ve been looking for. Currently I have to calculate many percent. I had been looking on this website http://www.excel-aid.com/excel-percentages-calculating-percentages.html but I was looking for something shorter like your post. Thank you!