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.
Here is how to apply percentage format using it: 1  Select the cell (range of cells). 2  Go to Home â> Number and click on the dialog launcher (a tilted arrow icon at the bottom right of the group). 3  In the Format Cells dialog box, within the Number tab, select Percentage in the Category list. If you want to change the number of decimal places to be displayed, use the Decimal places option on the right. For example, if you want to display the value with 2 decimal places, make it 2.