I'm trying to format a cell with percentage formatting so that when I enter a fraction of a percent, I won't have to enter two leading zeros. For example, .22% now has to be entered as .0022; if I enter .22, then it comes out as 22%. Any suggestions?
Of course the reason that .22 comes out 22% when you enter it is because .22 is in fact twenty two percent not .22 percent, excel just converts the fraction that you enter into a percent. So to get around that you can use a formula that will divide by the number of integers that are necessary to produce the result you want. If you want .22 to equal .22% then you can divide by 100.
So in the column that you want to have the percentage appear (assume its column D), you might have the formula +B divided by C, and in C you have the number 100. In B you enter the .22. So the result in column D is .22%. (after you have formatted the column using percentage and two decimal places)Try this out and you will see what I mean.
Another way to do it is to use the formula +B&C, where in B you put your entry of .22, and in C you put the % sign. This formula will put the two together and give you .22%, but the result will be text and not numerical.
Hope this helps.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here