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.
Image courtesy of Microsoft. Work with Percentage Formulas. Use the formula (b-a)/b to calculate a percentage difference between two numbers. For example, given the discount price $2,000 in cell A4 and the original price of $5,000 in cell B4, write  =(B4-A4)/B4  to generate the difference: 60%.ight-click a cell, choose Format Cells and pick Percentage to specify how many decimal places appear in your percent. If you use the % icon on the Home tab, this option defaults to zero decimal places. This method also works to set the formatting on previous versions of Excel that don't have the ribbon bar.