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.
Ensure the cell where you want to store the percentage is selected and click inside the Formula field. Step 5. Type =Cell1/Cell2 (without the quotations) and press Enter to find the percentage of the two cells. Replace Cell1 and Cell2 with the correct cell numbers -- B2 and C4 for example.Step 6. Press Ctr-S to save the changes to your spreadsheet, if desired.tep 1. Open the spreadsheet you want to edit in Excel and locate the two cells. Locate the cell where you want to store the percentage. Step 2. Right-click the cell where you want to store the percentage and choose Format Cells from the context menu to open the Format Cells window.