Using old plans and maps that I rectified and georeferenced I determined approximate coordinates for certain points. These coordinates are in decimal degrees and are split in two colums latitude and longitude in the relevant excel table. Now I imported the excel table in xls format and set the coordinate system to WGS84 Web Mercator, and while the relative position of the points to each other seems correct, their absolute position is wrong; they are in the middle of the base map and not in Belgium, which does obviously not exist in the ocean near Africa.
What am I doing wrong?
I was under the impression that WGS84 web mercator was the default setting for ArcMap10. I also tried exporting the imported xls into a shapefile. Or am I doing something wrong with the excel since every time I get a 'ArcMap drawing Errors: one or more layers failed to draw. syntax error (missing operator) in query expression ' notification. I tried changing the ',' into '.' in the DD notation but then my computer reads it as numbers instead of coordinates.