Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Skip to search results
Buy Microsoft Office 2007 (Legacy)
Change the separator for thousands and decimals
Change the character used to separate thousands or decimals By default, Microsoft Excel uses the system separators that are defined in the regional settings in ...
Display minus signs on negative numbers
Change the display of negative numbers You can display negative numbers with minus signs, with brackets, or in red (with or without parentheses). Select the cel...
Display numbers as dates or times
Select the cell or range or cells that you want to format. How to select a cell or a range To select Do this A single cell Click the cell, or press the arrow ...
Display numbers as fractions
Use the Fraction format to display or type numbers as actual fractions, rather than decimals. Select the cell or range of cells that you want to format. How...
Display numbers as percentages
In Excel 2003, use the Percentage format to display your cells using the percent sign (%).
Display numbers as postal codes, Social Security numbers, or phone numbers
Display numbers as postal codes, phone numbers, or Social Security numbers Select the cell or range of cells that you want to format. How to select a cell or ...
Display numbers with scientific notation
Display numbers in scientific (exponential) notation The Scientific format displays a number in exponential notation, replacing part of the number with E+ n ,...
Number format codes
Important notice for users of Office 2003 To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3) . The...
Reset a number format
Reset a number to the General format The General format is the default number format that Excel applies when you type a number. For the most part, numbers tha...