Decimal Numbers Imported from dBASE Are Rounded

• 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        : 

Last Reviewed: March 12, 1999