Microsoft KB Archive/63647

Works: Entering Slash (/) Changes Column to Date Format

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

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

Making an entry such as 2/3 in a column (field) in the Works Database causes the entire field to display in a date format.

To correct the problem, reenter the intended number or text string and select Format General (ALT, T, G). If you are entering a fraction, precede it with a 0 and a space, for example “0 2/3” (without the quotes). Works 2.0 will convert the fraction to its decimal equivalent, while Works 3.0 will display it as a fraction, changing the entire field to the Fraction format. If the field format must be kept the same, use a leading double quotation mark (for example, &quot;2/3) to allow Works to treat the entry as a text string rather than a date or fraction.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.