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.
After applying the percent format to the column with the percent change formula, you will get the following result: If you want to calculate percentage change compared to a certain cell, then you need to fix the reference to that cell by using the absolute cell reference with the $ sign, e.g. $C$2. Enter the formula =C2/B2 in cell D2, and copy it down to as many rows as you need. 2  Click the Percent Style button (Home Number group) to display the resulting decimal fractions as percentages. 3  Remember to increase the number of decimal places if needed, as explained in Percentage tips.