This content has been marked as final. Show 3 replies
In Excel you should be able to create a new column and use =VALUE(text) insert the first row of your x value in, copy paste for all x, and do the same for all y coordinates. Once you have done this the x,y coordinates should be numbers now. Copy the new column and paste > paste special > Value. Once you have done this you should not run into the issue of the fields not being formatted as a number. User the following KB artible to walk your through the rest of the process.
HowTo: Import XY data tables to ArcMap and convert the data to a shapefile
This works YAY! Thank you for the info.
But my new problem is that the point(s?- I can't tell if it's even importing more than one point) show up off the coast of west africa, when the gps coordinates are from California. I specified the coordinate system as WGS 84, as I read that this is what the Bing map basemap is in, but maybe I chose the wrong one?
This is what comes up in the properties
Projected Coordinate System: WGS_1984_Web_Mercator_Auxiliary_Sphere
Linear Unit: Meter
Does this look like the right projection for matchup on the Bing Aerial basemap?
Assuming the coordinates are basic lat/long in decimal degrees, It should probably be in WGS 1984 (Geographic coordinate systems=>world=>wgs 1984 in the define projection dialog, not WGS_1984_web_mercator_auxillary_sphere)