File Saved in WK3 Displays Numbers Incorrectly in 1-2-3 (96379)



The information in this article applies to:

  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0c
  • Microsoft Excel for Windows 4.0a
  • Microsoft Excel for Windows 3.0

This article was previously published under Q96379

SYMPTOMS

When you open a Microsoft Excel file that has been saved in a WK3 file format in Lotus 1-2-3 version 3.0 or later, the formula bar will display all numbers with two or more digits to the right of the decimal point out to sixteen decimal places.

WORKAROUND

To display the number correctly, save the file in WK1 file format and reopen it in Lotus 1-2-3.

STATUS

Microsoft is researching this problem and will post more information here in the Microsoft Knowledge Base as it becomes available.


Modification Type:MinorLast Reviewed:8/15/2005
Keywords:KB96379