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))*60),"0' ")&TEXT((G17*60-INT(G17*60))*60,"0.0000")&""""

but the negative decimal degrees throws it. for example I have -0.308733139 and should give me -0d 18' 31.4393" but instead it gives me -1d 41' 28.5607"

The other problem I have is once I have this text dms value I need to convert it back into decimal degrees in order to do more calculations with it.

If anyone can please help me I would greatly appreciate it

Regards Matt