Formatting cell to Percent displays extra zeros

[servcoor]

Hi, all. On a worksheet that someone else provided (I do not have access to the original data) there are numbers displayed across several columns and rows. I need to display those numbers as percentages. When I format the cells to percent, the numbers display with two zeros before the decimal place. (I actually want zero decimal places, but even then there are still two zeros added to the number.) So, 103 becomes 10300%. 95 becomes 9500%. I don't think I've ever encountered this before and can't find a way to prevent this. Any help is appreciated!

Thanks!

 

[Andrew Fergus]

103 formatted as a percentage is 10300%

To get the value you want you will need to divide the values by 100 instead of just changing the format. To do this on all of the data try the following (first save a backup of your spreadsheet):

Enter the value 100 in a cell that isn't currently used
Copy the 100 value
Select the data you want to change
Paste Special (set to values, select the option divide)
Ok

This will divide all of the values by 100 so when you change the format to percentage, you will see the values you want.

HTH, Andrew

 

[servcoor]

Thank you, Andrew, for the help. And I apologize for not replying sooner...but your suggestion did work for me and I wanted to be sure to give you props for the help!