The code, itself, does not compensate for negative coordinates so we have added a formula to use with the conversion to compensate for this. Posted in Excel | Tagged DD, decimal, degrees, DMS, Excel, minutes, seconds Decimal-Degrees (DD) to Degrees-Minutes-Seconds (DMS) with Python ...
Forum:Excel Questions M DMS to decimal and back again Hi there I am wondering if anyone can help me. I am working in longitude and latitudes in the southern hemisphere (Latitudes are negative) I have put in the following cell formula =TEXT(INT(G17),"0° ")&TEXT(INT((G17-INT(G17)...