I am very new to GIS.
I have a dataset in Excel containing XY coordinates of points. These coordinates are said to be in WSG84, but have different decimal places lengths. Longest of them have 9 decimal places. They have 3 digits before decimal points. So a 9 digit coordinate is XXX.YYY.ZZZ or a 6 digit one is XXX.YYY. I want them all to be in decimal coordinate system. Is there way that I can do this automatically in Excel?
When I try to convert the data to XY points, ArcMap disregards the decimals even though both the shape layer and the points layer are in WSG84 format. Thus, drawing the points to a totally unrelated space.
Example Coordinates from the dataset;
362.935.938 339.309.883 363.010.152 3.396.492 404.244.154 264.695.215 40.63 26.83 41.128.471 29.145.429 41.305.968 286.615.491 411.788.295 291.018.963 4.102.785 2.906.803 4.112.674 2.915.039 41.019 28.571 413.621.671 285.677.379