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.
(You can modify the number of decimal places in the format, if necessary.). The other way that you can display negative percentages in red is to use conditional formatting by following these steps: 1  Select the cell (or cells) that may contain negative percentages. 2  Choose Conditional Formatting from the Format menu.3  Leave the first drop-down list set to Cell Value Is. Select the cell (or cells) that may contain negative percentages. 2  Choose Cells from the Format menu. 3  Excel displays the Format Cells dialog box. 4  If the Number tab is not displayed, select it. 5  In the Category list, choose Custom. 6  The dialog box changes so you can enter a custom format.