New to GIS and Ive been trying to figure this out for a while. I have an excel sheet with CT names such as 0128.03, 0128.04, starting from 0001.00 and up. Not all CTs have .01, .02 at the end just .00. anyways when I transfer it to a dbf and open it up in arc the field shows with no decimals. I did a custom format for 0000.00 but for some reason 0128.03 shows up twice and I was missing 0128.04. I realized the duplicate of 0128.03 actually was 0128.03999999 and should be 0128.04 theres others doing the same thing as well. I have no clue how to get 128.04 or stop the continous decimal. Do I format the cells a certain way in Excel? I need these values to be correct so i can join the CT field with another table.

  • 2
    instead of saving to a dbf, try saving to a 97-2003 .xls file.
    – gm70560
    May 24, 2013 at 17:12
  • I saved it as a .xls first then export from arc as DBF. and CT is the field head and the numbers are the values
    – user18492
    May 24, 2013 at 17:22
  • 2
    You might find my explanation at quantdec.com/SYSEN597/GTKAV/section4/chapter_15a.htm#Recipe to be helpful.
    – whuber
    May 24, 2013 at 17:23
  • Wouldn't you be better off is exporting the data as a CSV then in ArcGIS export that file to a DBF? Meanwhile, do a table join by CT_ID for the whole layer and then export the joined layer as its own layer?
    – dassouki
    May 24, 2013 at 19:12

2 Answers 2


Try saving as CSV and see all the answers and comments on How to best prepare csv files for use in arcgis. Once it is imported into ArcGIS you can export/convert to dbf or gdb or other table format.


you might try formatting the column as text, which will be necessary to preserve the leading 0s.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.