AT Museum manager Joe EarthTone Harold did an informal social media survey of hikers earlier this year, to learn about the sources of trail names on the Appalachian. Of 223 respondents, 77% said they had a trail name. Of these, 80% had been given their name and 20% chose their own.
When creating a formula that should return a percentage value, you will need to format the field correctly to get the % sign to properly show. Right-click on the field in question, select Format Field. Click the Display Currency Symbol checkbox. Click the Customize button. Click the Currency Symbol tab.
1 Letâs say that you type 10 into cell A2, and you then apply the percentage number format. 2  Because Excel multiples your number by 100 to show it as a percentage (remember that 1% is one part of one hundred), youâll see 1000% displayed in the cell, not 10% . Decimal places: Press Ctrl + 1 to open the Format Cells dialog box, and then click Percentage. 2  In the Decimal places box, enter the number of decimal places that you want to display. 3  For example, if you want to see 10% instead of 10.00%, enter 0.