Microsoft KB Archive/47977

Multiplan: Formatting Social Security Numbers PSS ID Number: Q47977 Article last modified on 03-28-1990 PSS database name: D_MPlan

3.00 3.02 3.03 4.00 4.01 4.20

MS-DOS

Summary:

Multiplan Versions 4.00, 4.01, 4.20 allow you to create custom formats. For example, Multiplan automatically inserts hyphens in the appropriate place within a Social Security number. The number itself will be treated as a Value rather than Alpha.

To create the custom format, choose Format Cells, and specify a range. Tab twice to the format field and type “###-##-####” or “000-00-0000” and press the enter key. Numbers will automatically contain the required dashes.

Multiplan Versions 3.x require that you use the Alpha command from the main menu each time a Social Security number is entered. The sting will be treated as Alphanumeric characters rather than a value.

More Information:

To create a custom format for Social Security numbers under Multiplan Versions 4.00, 4.01, or 4.20, follow these steps:


 * 1) Adjust the width of the column to at least 12 characters using Format Width.
 * 2) Choose Options and set the “learn:” field to Yes.
 * 3) Choose Format Cells.
 * 4) Enter the range of cells in which the Social Security numbers will be entered.
 * 5) Tab twice to the “format:” field and enter the following (without the quotation marks): “000-00-0000”. Press the ENTER key.

At this point, any number entered in the specified range of cells automatically contains hyphens at the appropriate locations within the number.

Copyright Microsoft Corporation 1990.