Microsoft KB Archive/34152

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Importing Lotus 1-2-3 Data with Zero Decimal Places

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

4.00 5.00



If you import spreadsheet data into Microsoft Word for DOS version 4.0 from Lotus 1-2-3 with decimal places suppressed to zero, the text appears with the number of decimal places originally entered, instead of zero. However, this problem does not occur if you suppress the decimal places one or two places. In these situations, text appears in Word as desired.

Microsoft Word for DOS version 5.0 incorrectly imports spreadsheet data from Lotus 1-2-3 if you apply the following formats in the data or range areas specified with the Library Link Spreadsheet command:

Global format, two decimal places Fixed, zero decimal places Comma, two decimal places Negative parenthesis

Microsoft Word versions 4.0 and 5.0 were not tested with Lotus 1-2-3 release 3.0, and do not recognize the WK3 file format used by Lotus 1-2-3 release 3.0.

Data from Lotus 1-2-3 release 3.0 files that have been translated into Lotus 1-2-3 release 2.0 (WKS file format) or release 2.1 (WK1 file format) cannot be imported correctly into Word 5.0 with the Library Link Spreadsheet command.


The following is an example of the problem encountered in Word 4.0:

                               Text with Decimal Places Suppressed

Text Entered in Lotus 1-2-3 to Zero in Lotus 1-2-3 ————————— ———————————-

23.454 23 12.40 12 1.03 1 34 34

Text Transferred into Word 4.0 ——————————-

23.454 12.40 1.03 34

To work around this problem in Word 4.0, do the following:

  1. In Lotus 1-2-3, suppress decimal places to two.
  2. In Word, run the Library Link Spreadsheet command.
  3. Select the imported text and replace the two decimal places using the Replace command. The text to be replaced appears as “.??” (a period and two question marks, without the quotation marks), and the replacement text appears blank.

KBCategory: kbother KBSubcategory: Additional reference words:

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