I have a data set containing XY coordinates of points. It's in Excel. I am very new to GIS and I have two questions regarding this data set.

Firstly, 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?

My second question is about importing these coordinates to ArcMap. 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

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

I have a data set containing XY coordinates of points. It's in Excel. I am very new to GIS and I have two questions regarding this data set.

Firstly, 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?

My second question is about importing these coordinates to ArcMap. 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.

I have a data set containing XY coordinates of points. It's in Excel. I am very new to GIS and I have two questions regarding this data set.

Firstly, 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?

My second question is about importing these coordinates to ArcMap. 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