Microsoft KB Archive/61102

Works: Entering Fractions in a Spreadsheet

PSS ID Number: Q61102 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

= SUMMARY =

The proper syntax for entering fractions in the Works Spreadsheet is “M n/d”, where “M” is an integer, “n” is the numerator and “d” is the denominator. Works 3.0 will then display the number as a fraction. Works 1.x and 2.0, which do not include a format specifically for fractions, will display the decimal equivalent of the fraction.

A value for M must be entered or Works will recognize the cell as a date rather than a fraction. For example, 7/8 must be entered as 0 7/8 to be recognized as a fraction.

= MORE INFORMATION =

In Works 1.x or 2.0, when a date is entered into a cell, it changes the cell’s format to a date format. Therefore, if a number such as 7/8 is entered into a cell and 0 7/8 is entered on top of it, a series of pound signs will fill the cell because it will be changed to a date format.

In Works 3.0, the above procedure does not cause pound signs, but correctly changes the format. To change the cell back to a numeric format in Works 1.x or 2.0, do the following:


 * 1) Choose Format (ALT+T).
 * 2) Choose General (or any numeric format being used).

In Works this procedure converts the cell back to a numeric format and the correct decimal equivalent of the fraction will appear in the cell.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.