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.
Create a custom format. Select the cell or cells with negative percentages. To select multiple cells, hold down the Ctrl key as you select each cell. On the Home tab, click Format Format Cells. In the Format Cells box, in the Category list, click Custom. In the Type box, enter the following format: 0.00%;[Red]-0.00% .Now the negative percentage stands out, formatted in red. Tips Custom formats are saved with the workbook. The next time you need to apply it, follow steps 2 and 3 above, and youâll find it in the Type list.n a worksheet, select the range of cells in which youâll enter negative percentages. On the Home tab, click Conditional Formatting New Rule. In the New Formatting Rule box, select Format only cells that contain.