This is a good place to talk about formatting. There are two ways you as a user may approach formatting. The first involves changing the way numbers are displayed without changing the underlying number. You may select this approach when you want an interim report that does not change the underlying number. The second involves changing the underlying number for both display and further calculation.
The median ratio was calculated as 0.932473. By right clicking on the cell containing the median ratio (D103), a dialog box appears that allows the user to make several different changes. Using the Number tab and selecting Percentage, the user can change the display of the median to a percentage.
Notice when the decimal places are changed to 0 and we hit OK the median changes to 93%. However, all other figures on the worksheet remain unchanged. That is because only the appearance of the number has changed.
