To distinguish between different types of numbers, add a format, like currency, percentages, or dates.

  1. Select the cells that have numbers you want to format.
  2. Click the Home tab, and then click the arrow in the General box.

Format Number box on the Home tab

  1. Pick a number format.

Number format gallery

If you don’t see the number format you’re looking for, click More Number Formats.