Function to Convert GPS Decimal to GPS DMS ie (Degrees, Minutes and Seconds)

[USMC7312]

When I use this function it returns 0 instead of the value that I see set to ConvertDegree when I set a breakpoint on it. Any thoughts on why this is not working as expected?

Please Login or Register  to view this content.

[MrShorty]

No ideas. I copied that function into a blank worksheet, entered 41.5 into a cell, then entered =convert_degree(A1) into an adjacent cell and the result was 41° 30' 0". There must be something else going on in how you are using or entering the function or in the input data or in your Excel installation that is causing it to return 0.

I could not see what the With Application...End With was doing, so I commented it out, and the result stayed the same.

Can you give more information? I think the problem is with something outside of the function procedure.

[shg]

Another way:

	A	B	C
1	10.46	10° 27' 36"	B1: =DD2DMS(A1)
2	-10.46	-10° 27' 36"
3	-164.251	-164° 15' 3"
4	224.7536	224° 45' 13"
5	-290.505	-290° 30' 18"
6	354.6703	354° 40' 13"

Please Login or Register  to view this content.