Microsoft KB Archive/113712

= Works: Maximum Number of Significant Digits in DB Field, SS Cell =

Article ID: 113712

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q113712



SUMMARY
Database fields and spreadsheet cells hold no more than 15 significant digits.



MORE INFORMATION
Any number entered into a spreadsheet cell or database field retains only the number of significant digits on the left; any additional digits on the right are replaced with zeros.

For example, if you type the number 1234567890123456789 in a spreadsheet cell, Works changes the number in the formula bar to 1234567890123450000.

WORKAROUND
Enter the number as text by placing a quotation mark (") in front of the number (for example, "1234567890123456789). Note that the number cannot be used in mathematical computations or functions while it is in text form.

In Works 2.0 and 3.0, each cell or field can hold up to 255 text characters. In Works 4.0, 4.5, and 4.5a, each cell or field can hold up to 2,047 text characters, except for default value fields in the database, which are restricted to 255 characters.

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a kbhowto Max Loose Loss Format Change w_works

Keywords: kbinfo KB113712

-

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

© Microsoft Corporation. All rights reserved.