Question related to latitude and longitude.

Hello Everyone - I have to put latitude and longitude in data entry. How to format cell for that? Please helps...???

Platinum Contributor

Nov 18, 2020

If you use a German-language Excel then I would enter the number with the decimal separator comma: -12.8815599.

The decimal separator point is e.g. used in English language versions.

Cell format:

## "°" ## "'" ## "." ## "' '"

5105263791

5105°26'37.91'

322988466

322°98'84.66''

or with formula

=TEXT((LEFT(A3,LEN(A3)-8)&","&RIGHT(A3,8))/24,"[h]° mm' ss,0''")

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here

Iron Contributor

Nov 18, 2020

Hello Sir - Thank you for giving a solution. I tried both but it is not working.
I am from india (english language)

Forum Discussion