More Number Format

Customize the display format.

Change to social security number format

Perform the following to change the data number format.

1. Select the resident social security number entered incorrectly.
2. Click Format-Number Format-More Number Format.
3. In the Number Format dialog box, under Category, click Special.
4. Click Social Security Number in the Type list.
5. 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.