Convert coordinate system arcmap 10.3

Question

Hi,

I have the list of the points with lat and long decimal degree, so I follow the steps to create the shape file as add data (text) display data and export as a shapefile, before adding the layer was set to the GCS WGS84 because my coordinates are in it, now I need to convert it to the UTM zone N39, with projections tools I did it but still the units in decimals and it shows in a different place the points is in the Caspian Sea, I need to get the coordinate of point with meters, please if you have any suggestion let me know.

Thank you for your attention.

DanPatterson_Retired · Answer

If the mixed values are in the same table, then you will have problems.  If the DMS values are in a separate table

Convert Coordinate Notation—Data Management toolbox | ArcGIS Desktop

might be useful.  If you already have stuff in a spreadsheet, fix it there

OrkhanAbdullayev · Answer

And should I do that conversion in other software as excel by applying formulas DMS to DD, or is it possible in Arcmap with table field calculator?

Sorry, too much question

DanPatterson_Retired · Answer

No... you need to convert the DMS coordinates to decimal degrees.  DMS aren't 1 number, they are 3 and can't be represented in a numeric field properly in any event.  Don't skip these important steps, otherwise they will results in more problems and questions which you obviously don't want