AnsweredAssumed Answered

CSV file displaying null value for decimal cells

Question asked by ckeil78 on Aug 13, 2015
Latest reply on Aug 15, 2015 by csgeosol1

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.

 

Thanks

Outcomes