See Also:
Office.com results
Available number formats
Article 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...
Excel 2003
Change the default country/region
Article 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
Article 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...
Excel 2003
Display numbers as dates or times
Article 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 ...
Excel 2003
Display numbers as fractions
Article 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...
Excel 2003
Display numbers as percentages
Article In Excel 2003, use the Percentage format to display your cells using the percent sign (%).
Excel 2003
Display numbers as postal codes, Social Security numbers, or phone numbers
Article 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 ...
Excel 2003
Display numbers with scientific notation
Article Display numbers in scientific (exponential) notation The Scientific format displays a number in exponential notation, replacing part of the number with E+ n ,...
Excel 2003
Display only the last four digits of identification numbers
Article 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...
Excel 2003
Repeat a character in a cell
Article 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 ...
Excel 2003