More Number Format

Customize the display format.

Change to social security number format

Perform the following to change the data number format.

Select the resident social security number entered incorrectly.
Click Format-Number Format-More Number Format.
In the Number Format dialog box, under Category, click Special.
Click Social Security Number in the Type list.
In the Number Format dialog box, click OK to close the dialog box and apply the selected format.

More Information

Number Format Dialog Box

Category

General
A data format in the input state that has not been formatted.

Number
Specify the number of decimal places, unit separators, negative number display, and more.

Currency
Specify a currency symbol to a numeric value.

Accounting
Cells formatted as accounting display the money sign and number in the same place, regardless of the number of digits.

Date
Display a numeric value as a time format.

Time
Display a numeric value as a time format.

Percentage
Display a numeric value as a percentage format. With percentage formatting, the cell value multiplied by 100 appears with a percent sign.

Fraction
Display a numeric value as a fraction format.

Scientific
Display a numeric value as a scientific format.

Text
Format a numeric value into text and display as entered. If a cell value formatted as text is used in a formula, it is not included in the calculation.

Special
Display numeric values in the form of zip codes, phone numbers, and social security numbers.

Custom
You can select any number format of choice.

Sample

Preview the data in the cell to which the specified display format is applied.

OK Button

Apply the settings.

Cancel Button

Discard settings and close the dialog box.

See Also