Question related to latitude and longitude.

%3CLINGO-SUB%20id%3D%22lingo-sub-1902237%22%20slang%3D%22en-US%22%3EQuestion%20related%20to%20latitude%20and%20longitude.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1902237%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E%26nbsp%3BHello%20Everyone%20-%20I%20have%20to%20put%20latitude%20and%20longitude%20in%20data%20entry.%20How%20to%20format%20cell%20for%20that%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20helps...%3F%3F%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1902237%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1902402%22%20slang%3D%22de-DE%22%3ESubject%3A%20Question%20related%20to%20latitude%20and%20longitude.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1902402%22%20slang%3D%22de-DE%22%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20you%20use%20a%20German-language%20Excel%20then%20I%20would%20enter%20the%20number%20with%20the%20decimal%20separator%20comma%3A%20-12.8815599.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20decimal%20separator%20point%20is%20e.g.%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eused%20in%20English%20language%20versions.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ECell%20format%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%23%23%20%22%C2%B0%22%20%23%23%20%22'%22%20%23%23%20%22.%22%20%23%23%20%22'%20'%22%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E5105263791%3C%2FTD%3E%3CTD%3E5105%C2%B026'37.91'%3CTABLE%20border%3D%221%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E322988466%3C%2FTD%3E%3CTD%3E322%C2%B098'84.66''%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eor%20with%20formula%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3DTEXT((LEFT(A3%2CLEN(A3)-8)%26amp%3B%22%2C%22%26amp%3BRIGHT(A3%2C8))%2F24%2C%22%5Bh%5D%C2%B0%20mm'ss%2C0''%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1902451%22%20slang%3D%22en-US%22%3EBetreff%3A%20Question%20related%20to%20latitude%20and%20longitude.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1902451%22%20slang%3D%22en-US%22%3EHello%20Sir%20-%20Thank%20you%20for%20giving%20a%20solution.%20I%20tried%20both%20but%20it%20is%20not%20working.%3CBR%20%2F%3EI%20am%20from%20india%20(english%20language)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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

Please helps...???

5 Replies
Highlighted

  

 

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:

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

 

51052637915105°26'37.91'
322988466322°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

@Zan_Hanifee

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

@Zan_Hanifee 

 

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)

Highlighted

@Nikolino 

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