Hi all!

I received a spreadsheet of attributes from which I need to create points. This is something I do a lot, but in the table I received from an outside source the Lat Long are just listed in a string of numbers and I don't know how to convert them to something the software will recognize. Or maybe that's not my problem at all and I need to find a different projection - but I don't think so.

The first time I tried this, it did seem that I used the wrong projection. The points did plot. I zoomed to layer and they were off the edge of the globe somewhere, but I could see them. So I tried again w/different projections, some standard ones.

Now, I Created Points from Table and the layer shows up in my catalogue/ Drawing Order, but nothing displays in my map. When I zoom to layer, the detail area doesn't change at all. I stay in the same place, but nothing displays. It doesn't matter where I am in the map. I've maneuvered around the geography a bit, and every time I stop somewhere and Zoom to Layer of these points, nothing happens. I stay wherever I was, as if that's where the layer should display, but nothing displays. Does that make sense?

So I think that part of my problem is that my Lat Long entries are not in a useable format. The top entry, for example, needs to be something like 39 79'10.44 and -105 15'86.11. Doesn't it? I thought maybe the software would know how to convert those, but it doesn't seem like it. And I'm not sure how to create a formula that will re-format those values in a new column in Excel so I can import it into Pro, or how to convert the values in ArcPro.

Does anyone know the answer? Thanks, all!!