Can't get excel to display latitude and longitude properly

Hi everyone, I'm need help with my worksheets. I have sheets with hundreds to thousands locations of gps coordinates each, but I can't get my excel to display them properly.

When I use the format .csv all the columns get cramped into a single column, and the latitude/longitude data is displayed correctly (eg -64.789548), but once I separate the columns properly either by text to columns command, or by getting the data externally and choosing to separate it by commas all the lat/long data displays incorrectly (eg. -64.789.548).

Is there any way to get the converted sheets to display them correctly? Preferably without losing the converted sheets, since there are too many sheets I'd have to convert again.

I've tried to upload samples of both formats of worksheets.

Thank you so much in advance for any help.

Yes, the decimal separator was indeed wrong in the conversion process, thank you. But now that I switched it back to ".", my numbers show up as -58,030128 (with an "," instead of ".") which is better but still not ideal, do you have any idea on why that might be happening?

Also, do you know if there's a way to fix the already converted tables that display, for instance, -58.030.128 or do I really need to convert them all back again?

Thank you once more.

@Malebus;

While using Text to Columns method in your CSV file, you can choose the Lat-Lon columns' format as text so that, data will appear as just seen on the CSV file.

.

MrShorty

They aren't consistently 6 digits, I guess I'll just do them all over again. I also made sure Excel was using '.' for decimal aswell, so I don't know why it still goes wrong and puts a ',' in its place... Thank you for all your help.

Haluk

This actually solves the problem of getting the number to display as it should, even though I don't understand what was causing the problem in the first place. Thank you.