By default the results are displayed as decimal numbers. To calculate the percent change in excel we need at least two numbers from different time periods. Excel Percent Style button for percent changes.
When you start typing average you will get a few options to choose.
Excel Percent Style button for percent changes. Percentage of Days spent in USA 5 15 100 3333 Percentage of Days spent in Home Town 10 15 100 6666. Enter the formula shown below. To calculate the first percentage change enter this percent change formula in C5.