Hello. This is my first question on the forum. I think this is something simple that I am missing. I have added a csv file to ArcMap 10.2.1 and I would like to join it to a shapefile. When I bring the csv file in all the decimals go <Null>. Below are screenshots from Notepad, Arc Catalog, and ArcMap (left to right).
I assume this a data format issue and I have played around with it in Excel and ArcMap, but have not been able to resolve the issue. The data format is General right now in Excel. When I change to numerical all the values go Null.
Below is a screenshot of the Field Properties and Number Format for the column.
I would really appreciate some help on this. I have done a lot of internet searching and cannot seem to find the answer.