Microsoft KB Archive/28306

Database: Format of Value Typed in Overrides Column Formatting

PSS ID Number: Q28306 Article last modified on 10-16-1998

1.x 2.00 3.00

MS-DOS

=
========================================================= 1.x 2.00 3.00 MS-DOS ENDUSER kbusage kbprb —————————————————————— The information in this article applies to:

 == Microsoft Works for MS-DOS, versions 1.x, 2.0 and 3.0 == 

= SUMMARY =

If an entry in the database is typed with a different format than specified for that field, all entries for that field will take on the new format.

To avoid this problem, enter the “non-standard” format as text by placing a quotation mark in front of it.

= MORE INFORMATION =

The following is an example of the above problem:


 * 1) In the list screen, type 2/3/88 in field 1.
 * 2) Go directly below it (Record 2 field 1); enter $1.99.

The cell containing the date will now appear as ##########. This occurs because the cells are now formatted for dollars, and the numerical amount represented by 2/3/88 is too large to be displayed in the default cell width.

To avoid this problem, enter &quot;$1.99 instead of just $1.99.

KBCategory: kbusage kbprb KBSubcategory: dworkskb ====================================================================== Version : 1.x 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.