Hello,

I have a series of worksheets (~70) in which there columns that contain cells with what should be percentages reflecting efficiency. The problem is that the numbers were not entered in decimal format, so when I try to format the row as a percentage, the numbers are multiplied by 100, which is not what I want. All I want is to get a percentage sign to appear next to the numbers in these cells.

I have tried using a formula to convert the numbers to decimal form so that I could then format the cells as percentages, but then I have one row with percentages and another with numbers and no percentage signs, which is not ideal at all.

Does anyone know of a way that I can simply get a percentage sign to show up next to a number in a cell? Keeping in mind that I will have to do this to MANY worksheets and spreadhseets.

Thank you in advance