Nov 18 2020 10:13 AM
Hello Everyone - I have to put latitude and longitude in data entry. How to format cell for that?
Please helps...???
Nov 18 2020 10:30 AM
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'
|
Nov 18 2020 10:39 AM
Nov 18 2020 11:15 AM
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)
Nov 18 2020 11:25 AM
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
Nov 18 2020 03:38 PM