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
Available number formats
By applying different number formats, you can change the appearance of numbers without changing the number behind the appearance. A number format does not affec...
Buy Microsoft Office 2010
Change the default country/region
Changing the default country/region changes the standard settings for numbers, currencies, time, and date to those most commonly used for that country/region. M...
Access 2003, Excel 2003...
Create or delete a custom number format
If a built-in number format does not meet your needs, you can create a new number format that is based on an existing number format and add it to the list of cu...
Description of Office 2003 Service Pack 3
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 ,...
Display only the last four digits of identification numbers
Let's say, for common security measures, you want to display only the last four digits of an identification or Social Security number, credit card number, or ot...
Repeat a character in a cell
Let's say you want to create a fixed column of special characters to format a report or add periods to the end of a text column to provide a Tab leader similar ...