Easily Formatting Numbers as Percentages Without Automatic Recalculation

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

Go to Format Cells > Number Tab > Custom and enter 0"%", which gives a number with no decimal places and a percent sign. If you want decimal places, just add them: 0.0"%", 0.00"%", etc.

Thank you all for the replies. All of these steps still result in multiplying the value in the cells, does this just mean that I will have to put them into decimal form first?

Actually, Jakobshavn had the right idea, I just did it wrong the first time. Thanks y'all!