Forum Discussion
Question related to latitude and longitude.
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'
|
- Hello Sir - Thank you for giving a solution. I tried both but it is not working.
I am from india (english language)Format Cell:
[hh]°mm'ss.00\''
Convert Coordinates Latitude and Longitude
https://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.
Hope I could help you at least a little.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
cell format:
## "°" ## "'" ## "." ## "' '"
formula:
=TEXT((LEFT(A3,LEN(A3)-8)&","&RIGHT(A3,8))/24,"[h]° mm' ss,0''")
works too, please see the attached the file.
Thank you for your understanding and patience
Hope I was able to help you.
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
