I have recently installed ArcMap 10.4.1 in order to create a map of depth for some fishing ponds on a local refuge. I have an excel sheet of depths corresponding to exact coordinates. These coordinates were originally in DMS but I used the formula below to convert them into decimal degrees, taking into account a negative for western coordinates (the coordinates originate in Southwestern Louisiana).
degree + min/60 + sec/60 = DD
When I imported this data into ArcMap, it only displayed 2 points and the points were placed in the Gulf of Guinea near Africa. Upon further inspection of the attribute table, all of my X coordinates were transformed into 0, even though the initial values were not all the same. I thought it might be a projection issue, but I'm not sure which combination would match my base layer (basic satellite) and xy points.
I'm not sure exactly what I'm doing incorrectly, so if there is a possible solution to this, whether within excel before importing or within ArcMap, I would greatly appreciate any assistance.