Microsoft KB Archive/48442

Importing Spreadsheet Data with Zero Decimal Place Formatting

PSS ID Number: Q48442 Article last modified on 11-02-1994

5.00

MS-DOS

= SUMMARY =

When using the Library Link Spreadsheet command to import information from spreadsheet programs such as Lotus 1-2-3, Microsoft Works, or Microsoft Excel into Microsoft Word version 5.0, information formatted for zero decimal places does not import correctly. Information in the spreadsheet program is rounded, but information brought into Word 5.0 is truncated, cutting off the decimal, and therefore not rounding the value properly. This leads to different values occurring in the spreadsheet and Word 5.0.

Microsoft has confirmed this to be a problem in Word version 5.0. This problem was corrected in Word version 5.5.

A workaround to this problem is to save the spreadsheet file as an ASCII text file, then use Word’s Transfer Merge command to insert the information into a document. If the Library Link Document command is used to link the information, automatic updating from the ASCII file can be maintained.

= MORE INFORMATION =

An example of this type of problem is shown below:

Value Entered Spreadsheet Word 5.0 ————- ———– ——–

331.94 332 331 87.71 88 87

As seen here in the above example, Word 5.0 truncates the values formatted for zero decimal places and obtains different values.

KBCategory: kbother KBSubcategory: Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1994.