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.
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.