Problem: dBASE tables created in Microsoft Excel are missing decimals


When adding numerical values in Microsoft Excel, the values appear to have the right number of decimals places. Once this Excel file is exported to a dBASE format, the records don't retain the decimal places; instead, they are all rounded up. The decimals are missing when opening this dBASE file in ArcGIS.


Improper cell format in Microsoft Excel.

Solution or Workaround

  1. Open the original file in Excel.
  2. Right-click the field.
  3. Click Format Cells.
  4. Click the Number tab.
  5. Select Number under Category.
  6. Specify the number of decimal places.
  7. Export the MicroSoft Excel file as .dbf IV.
  8. Import the .dbf file in ArcGIS.