I've been asked to map point data that was collected in the field by manually writing down the coordinate from a Garmin NUVI 1490 LMT. They were put into a spreadsheet and sent my way which I was able to convert from DDM to DD in Excel. I've tried a bunch of different ways to import the points into ArcGIS using Add XY data with the same result (see attached image of street centerlines and points). The street centerine data is what I'm hoping they'll line up with (they're locations of street signs).
At first I suspected the projections I was using but after much experimentation I think it may be the conversion formula I used (found here: http://www.ozgrid.com/forum/showthread.php?t=155776).
Can anyone offer any advice as to where I've gone wrong and set me straignt?