you should probably convert the coordinates to decimal degrees first
As a side note, you must remove special characters and spaces from spreadsheet column names before importing into ArcMap.This is correct. Spaces can't be in the names. Use the "_" character.
I was having this problem too. My points were ending up in the middle of the ocean. Then I watched this video, and I finally understood the problem. Don't forget that choosing a projection verses geographic coordinate system is critical. Projected uses meters and the geographic uses decimals for lat and long.
Projected uses meters
Not exactly- it depends on the units used in the projection. UTM are typically meters: StatePlane in the U.S are typically feet.
While this is an older post, something that people often forget is when adding XY Longitude Latitude pairs is they need to add a - (minus) to the the longitude value when the data is in the western hemisphere. (Let's not forget the G [eography] in GIS...)
Well, sure it is slightly more complicated than I put it, but my data did have minus signs, and it was formatted properly, thus I was pulling out my hair. I was trying to use projected > UTM > WGS 1984 zone 13n, but the data would not cooperate. Using the geographic> World> WGS 1984, fixed my issue. It is a quick fix that might help others.