Access Keys:
Skip to content (Access Key - 0)

Changing Number Formats in Excel

Added by LAURA NICOLE MASSARO KAUFFMAN , last edited by LAURA NICOLE MASSARO KAUFFMAN on Mar 23, 2010 15:52


Changing Number Formats in Excel

If the numbers in Excel aren't doing what you expect them to do (eg. dates convert to regular numbers, numbers don't allow you to perform arithmetic, text that has numbers in it that should not be treated like numbers at all, percentages aren't acting as such, etc.), chances are they are not in the correct format. 

Here's how to format them:

  1. Select the cell(s) that you want to format.
  2. On the Ribbon, select the Home tab, and locate Number group:

Number Format dropdown menu (at the top)

chose how values are displayed: General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, Text, etc. 

Icon

Use the Text format for numbers that should be treated like text (i.e. should not be calculated).

Accounting Number Format button ($)

apply formatting based on Currency type (eg. US dollars, euros, etc.)

Percent Style button (%)

to display a value as a Pecentage.

Icon

Tip: You can also do apply percent formatting with CTRL+SHIFT+%.

Comma Style button (,)

change to Accounting format (comma separators for thousands) with no currency symbol

Increase and Decrease Decimal buttons

increases or decreases specified decimal places

Icon

Tip: Use Format Painter on the clipboard group to copy cell formatting without copying over any cell values!

#top