Trying to add xy coordinates from excel table. Table is formatted as number with eight decimal places. When I use the add x y data tool the decimal place comes up as "#" WTF? See image. Thanks in advance
"Excel does not enforce field types for values during data entry like standard databases do. Therefore, the field type specified in Excel is not used in determining the field type exposed in ArcGIS. Instead, field type in ArcGIS is determined by a scan of the values in the first eight rows for that field. If the scan finds mixed data types in a single field, that field will be returned as a string field, and the values will be converted to strings."
In your case, the issue is field headers, but another common issue with displaying XY data is that ArcMap is setting the field type as String because of mixed data types.