Question related to latitude and longitude.

Question

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

nikolinode · Answer

&nbsp;&nbsp;&nbsp;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.&nbsp;Cell format:## "°" ## "'" ## "." ## "' '"&nbsp;51052637915105°26'37.91' 322988466322°98'84.66''&nbsp;or with formula=TEXT((LEFT(A3,LEN(A3)-8)&amp;","&amp;RIGHT(A3,8))/24,"[h]° mm' ss,0''")&nbsp;I would be happy to know if I could help.&nbsp;NikolinoI know I don't know anything (Socrates)&nbsp;* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading hereExcel

excel · Answer

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

nikolinode · Answer

Excel&nbsp;&nbsp;Format Cell:[hh]°mm'ss.00\''&nbsp;Convert Coordinates Latitude and Longitudehttps://www.excel-exercise.com/convert-latitude-longitude/*Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.&nbsp;Hope I could help you at least a little.Thank you for your patience and time.&nbsp;&nbsp;NikolinoI know I don't know anything (Socrates)

nikolinode · Answer

NikolinoDE&nbsp;cell format:## "°" ## "'" ## "." ## "' '"&nbsp;formula:=TEXT((LEFT(A3,LEN(A3)-8)&amp;","&amp;RIGHT(A3,8))/24,"[h]° mm' ss,0''")&nbsp;works too, please see the attached the file.&nbsp;Thank you for your understanding and patienceHope I was able to help you.&nbsp;NikolinoI know I don't know anything (Socrates)&nbsp;* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here&nbsp;

sergeibaklan · Answer

Excel&nbsp;
You may check
Displaying Latitude and Longitude&nbsp;
Convert Coordinates Latitude and Longitude&nbsp;

Forum Discussion

Question related to latitude and longitude.

5 Replies

Resources