Microsoft KB Archive/85721

{|
 * width="100%"|

Negative Numbers Convert Incorrectly from BIFF and WKS Formats

 * }

Q85721

-

The information in this article applies to:


 * Microsoft Word for Windows, versions 2.0, 2.0a

-

SUMMARY
When a Microsoft Excel or Lotus 1-2-3 spreadsheet is converted into version 2.0 and 2.0a of Microsoft Word for Windows from BIFF or WKS format, negative numbers may not convert correctly.

Steps to Reproduce Problem

 * 1) In an Excel or Lotus 1-2-3 spreadsheet, type -9.99992346346 in a cell.
 * 2) From the Format menu, choose Number. Select the following Number format and choose the OK button:
 * 3) Save the file and exit Excel or Lotus 1-2-3.
 * 4) Launch Word for Windows. From the File menu, choose Open. Select the worksheet saved in step 3 above. Choose the OK button when prompted to convert the file from BIFF or WKS format.

The resulting negative number in the spreadsheet displays incorrectly as (19). The correct value is (10).

Word for Windows 2.0a-cd, 2.0b, and 2.0c shipped with an Excel converter that corrects this problem with Excel and Lotus 1-2-3 files. Upgrade to the latest version of Word for Windows.

Additional query words: 2.00 2.00a 2.0a-cd 2.00b 2.00c BIFF WKS Convert

Keywords : kbconversion

Issue type :

Technology :