Microsoft KB Archive/42282

From BetaArchive Wiki

Decimal Numbers Imported from dBASE Are Rounded



The information in this article applies to:


  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0





SYMPTOMS

When a decimal number is read in from dBASE to Microsoft Excel, that number is rounded to an integer.




CAUSE

This occurs when the numbers are formatted with "general" formatting in dBASE.



WORKAROUND

For the numbers to appear as decimals in Microsoft Excel, choose one of the decimal formats within dBASE.

Additional query words:

Keywords :
Version : 2.x 3.00 4.00 4.00a 5.00
Platform : WINDOWS
Issue type :
Technology :


Last Reviewed: March 12, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.