Your spreadsheet is the problem. You've got mixed and matched formats in the same column. Some are true numeric, while others should be treated as text (those with Alpha characters imbedded). I suggest you create a personal geodatabase, and create a table with the following fields: XCoord(double), YCoord(double), Waypoint(text). Load your excel data into that and go to work. Thank you for your help. It worked perfectly! I greatly appreciate it.
... View more