Microsoft KB Archive/121063

= Database Report Output Displays Decimal Numbers in a Text =

Article ID: 121063

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a

-



This article was previously published under Q121063



SYMPTOMS
The report output in a particular field is displayed as decimal numbers. For example, 0.4375 is printed instead of the text you entered.

This behavior occurs if the field name is a valid time or date (for example, a field named "10:30" or "9/13/94").



WORKAROUND
Change the field name to something other than a valid time or date. For example, you could use the field name "time10:30" for a time and "date9/13/94" for a date.

-or-

Place quotation marks to the left of the number. For example, type "10:30 (with the quotation marks) in the field.



MORE INFORMATION
This problem does not occur in Works 3.x and Works 4.x. Format the cell or field as text prior to entering any information.

Additional query words: 3.00 4.00 print preview percentage db rpt fmt incorrect wrong prt w_works

Keywords: KB121063

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.