Microsoft KB Archive/68297

Works: Formatting Column Width for Date or Number PSS ID Number: Q68297 Article last modified on 06-28-1993 PSS database name: D_WorKs

1.x 2.00 2.00a 3.00

MS-DOS

Summary:

If you enter a date or number in a spreadsheet or database, the column/field width should be set to the number of characters plus one. For example, if you enter a date containing eight characters (for example, 11/14/90), the column/field width should be set to 9. If the width for a date is not set wide enough, ######## will display instead of the number. If you do not set a number wide enough the scientific notation for the number will display.

More Information:

The extra space must be added to maintain a placeholder for the sign (+/-) of the number. When a number is positive (greater than zero), the “+” that would represent it as a positive number is not displayed, but its placeholder must still be present.

Copyright Microsoft Corporation 1993.