I have a list of Excel lat long coordinates in a spreadsheet that I want to import as points in ArcMap by displaying the XY Data.
lat lon
5235746 486124
5236799 487447
5238042 489453
523686 486487
5236528 49301
However, ArcMap does not seem to recognise/display my coordinate data as points. I think because there are some 6-numbered coordinates in there as well. How should I tackle this problem?