Converting GPS decimal value coordinates to DMS coordinate/format using Numbers

I have been given GPS decimal format for latitude and longitude and would like to convert them to a DMS (Degree, minutes, seconds) format. I know how to calculate this as well as how to add this in Excel, yet having issues figuring out how to do this using Numbers for Mac.


Can anyone tell me how to change the format in a cell so DMS (Degree, minutes, seconds) format is displayed? Thanks in advance.


Cheers

MacBook Pro 13″, macOS 10.15

Posted on Dec 19, 2020 8:15 PM

Reply
6 replies

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Converting GPS decimal value coordinates to DMS coordinate/format using Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.