longitude is the X, latitude is the Y, what did you use to plot it? Also, a good idea to get rid of the blank rows before bringing it into ArcMap. Further details required as to your procedure otherwise any further answers would be guessing.
I have narrowed it down to being a space most likely in my latitude. (in excel) Once its in ArcMap I can see in attributes Latitude is null. I am brand new to GIS, but I believe I plotted it with WSG 1984. (That's what I set) I am importing from text file with wizard, its delineated with tabs, and I have set General/Text appropriately. Now I am just unsure how to locate the space and delete it. To convert I manually typed in formula and applied row by row.
if that doesn't work, then your numeric fields have 'crap' in them and will have to be processed out.
You could convert the Excel sheet to table. Then create XY data from table using GCS_WGS_1984 spatial reference. Export the event layer to shapefile.
Using select by attributes, select the records where latitude = 0.
Start Editing, and delete the selected records. Save and stop editing.
The resulting data looks like this, with 9272 records.