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.
Open Microsoft Excel. Step 2. Enter the percentage you wish to add in cell B1 and include the percent sign, which automatically formats the number as a percentage. As an example, you might enter 50% in cell B1. To avoid confusion, enter Markup Percentage in cell A1, so you know the number in B1 is your markup.Related Reading: How to Formulate a Percentage in Excel. Step 3. List the values to which you wish to add a percentage in column A, beginning at cell A2.For dollar values, adding the dollar sign automatically formats the number as currency. As an example, you might enter $20.00, $10.75, $15.25 and $7.95 in cells A2 through A5.tep 3. List the values to which you wish to add a percentage in column A, beginning at cell A2. For dollar values, adding the dollar sign automatically formats the number as currency. As an example, you might enter $20.00, $10.75, $15.25 and $7.95 in cells A2 through A5.