Thanks a lot for this educational video. One thing I discovered after banging my head against the wall for a while is that depending on which "quarter" of the world you are in the +/- may be different for your decimal degrees. For example I am in South Africa, therefore south of the equator and east of the Greenwich Meridian so my latitude DDs need to be negative and my longitude DDs positive, which is the opposite to Moulay's example, as he must be based somewhere like the US (i.e. north of the equator, west of the GM. Otherwise very helpful, thanks!
I know it would be adding an extra step, but, for negative values aka Western Hemisphere, instead of subtracting, you can use the same formula used for lat vales, but when finished, simply multiply your DD by -1 and convert that way.
Thanks for this; your example was excellent; and now I know how to do this. I was quite easy; thanks again for putting this resource up for others. Well done; excellent work!
Good stuff. Is there a way to take a coordinate and reduce the digits, but keep the N or S at the end. For instance Let's say I have a 8 grid coordinate 3400N 2100W and I wanted to remove the 00 and at the end of the first and only 1 0 from the second and end up with 34N 210W is there a simple formula (conditional formatting or something I can do that could be applied to the cell?
In my case I am in north America so it is west of the prime meridian and negative. Depends what hemisphere you are in. The west and south are negative. The north and east positive.
Nice, but how does one work with a -00d20m35s latitude...? Similar to negative declinations in astronomy. This technique does bot handle this particular case.
i am trying to do something similar but my decimals are not lining up to separate. i tried to separate everything but it is over 15k rows. Any idea on how to do this? Thanks
Dennis Thacker You should check out my other video where I make DD to DMS, it does the function of separating out the degrees from the decimal portion you need. ua-cam.com/video/uOW88OfGhDs/v-deo.html
Thank you for this! quick solution to a two day headacke! I did the first step a little different tough, because my coordinates didnt align very well on account of different number of characters - so i couldnt use the fixed with very well - i first selected the two original columns and substituted º ' " and N/W with instead of deleting them after the separation. :)
@@sounny never hurts to provide the actual file in the video description below. haha. But thanks, really! For teaching me this. It's a little frustrating that Excel doesn't have a built-in formula for conversions like that. I can't imagine it to be too complicated.
Nice work on this. My only recommendation would be is to use a HD capture program. It's a little tough to read and follow along. Please keep up the good work, well done.
You helped me out of a jam but you didn't have your wallet turned on for me to send a payment. You seriously were a godsend, Thank you. Next time I hope I can pay you!
You can easily convert degree minute second values into decimal degrees value in Microsoft Excel instantly. The length and amount of data is not a problem at all. You can even convert degree-minute-second readings with garbage into decimal degrees within just a matter of click. See the video- ua-cam.com/video/2uVkE_mReBM/v-deo.html
hey #moulay_anwar.....i want to enter in the format cell the latitude and longitude and how to enter them correctly to covert them into decimal Please i want Fast reply for My own own work i want to finish it fast Furthermore, i want to add sybol to the lat/long like N Or W
I subtracted for the west, but for east just add instead. Use the formula for the north on the east and the formula from the west on the south and it will work for you.
Brilliant! I've been working with Excel for years and I never knew the text-to-columns function! Great solution.
Thanks a lot for this educational video. One thing I discovered after banging my head against the wall for a while is that depending on which "quarter" of the world you are in the +/- may be different for your decimal degrees. For example I am in South Africa, therefore south of the equator and east of the Greenwich Meridian so my latitude DDs need to be negative and my longitude DDs positive, which is the opposite to Moulay's example, as he must be based somewhere like the US (i.e. north of the equator, west of the GM. Otherwise very helpful, thanks!
I know it would be adding an extra step, but, for negative values aka Western Hemisphere, instead of subtracting, you can use the same formula used for lat vales, but when finished, simply multiply your DD by -1 and convert that way.
Thanks. This is cool
Thanks for this; your example was excellent; and now I know how to do this. I was quite easy; thanks again for putting this resource up for others. Well done; excellent work!
Thank you teacher, you saved 3 days time for me.
This is still the easiest and most precise explanation on this. Thank you for sharing.
Thanks a ton for this! Been trying for hours to figure this out and your video helped immensely.
Good stuff. Is there a way to take a coordinate and reduce the digits, but keep the N or S at the end. For instance Let's say I have a 8 grid coordinate 3400N 2100W and I wanted to remove the 00 and at the end of the first and only 1 0 from the second and end up with 34N 210W is there a simple formula (conditional formatting or something I can do that could be applied to the cell?
Thank you for this! I knew how to do the math formulas, but the first portion was very helpful to get my data out of the degree/minute format!
May you please tell me why you put -ve sign in front?
In my case I am in north America so it is west of the prime meridian and negative. Depends what hemisphere you are in. The west and south are negative. The north and east positive.
Nice, but how does one work with a -00d20m35s latitude...? Similar to negative declinations in astronomy. This technique does bot handle this particular case.
Thank you so much, Only 1 question: for Southern Hemisphere is simply just put negative on the formula?
Simple but yet didactical thanks a lot
i am trying to do something similar but my decimals are not lining up to separate. i tried to separate everything but it is over 15k rows. Any idea on how to do this? Thanks
email me a few lines of it in an excel sheet, I have to see it in order to advice. sounny@gmail.com
Dennis Thacker You should check out my other video where I make DD to DMS, it does the function of separating out the degrees from the decimal portion you need. ua-cam.com/video/uOW88OfGhDs/v-deo.html
Thank you for this! quick solution to a two day headacke! I did the first step a little different tough, because my coordinates didnt align very well on account of different number of characters - so i couldnt use the fixed with very well - i first selected the two original columns and substituted º ' " and N/W with instead of deleting them after the separation. :)
Thanx a lot bro It worked perfectly. U saved me a lot of time
Wouldn't it be simpler to just post the Excel sheet somewhere for download ?? :-)
go on then
You can give people a fish and they eat for one day, you can teach them to fish and they eat their whole life.
@@sounny never hurts to provide the actual file in the video description below. haha.
But thanks, really! For teaching me this. It's a little frustrating that Excel doesn't have a built-in formula for conversions like that. I can't imagine it to be too complicated.
Wow! You just saved me so much time! Thank you!
You just saved me a lot of time. Thanks a lot. Cheers!
Nice work on this. My only recommendation would be is to use a HD capture program. It's a little tough to read and follow along. Please keep up the good work, well done.
+Kevin Kev will do in the future, this was one of my first captures with quicktime.
Okay then, if it’s not a fixed what we can do ??
You helped me out of a jam but you didn't have your wallet turned on for me to send a payment. You seriously were a godsend, Thank you. Next time I hope I can pay you!
THANK YOU!!! this just saved me so much time/work!
Thank you very much. Excellent step by step description 👏🏾❤️🫶🏾
Hi Thanks for Video. Whats the reason for the No value pop up?
It means there is something wrong with formula. You are pointing to a blank cell?
THIS VIDEO MADE MY DAY. THANK YOU SO MUCH
Thank you! Easy and helpful tutorial :-)
if I am having a range of latitude for example 22º15' - 22º58' N the which value I should consider. Kindly reply soon
I'm amazed! Thanks man :)
You can easily convert degree minute second values into decimal degrees value in Microsoft Excel instantly. The length and amount of data is not a problem at all. You can even convert degree-minute-second readings with garbage into decimal degrees within just a matter of click. See the video- ua-cam.com/video/2uVkE_mReBM/v-deo.html
thx for tutorial, very useful example
This was extremely helpful. keep up the good work teach
Great video Hare krishna buddy
Great work!! Can you send the calculation to convert DDM (Degree* Decimal. Minutes') to DD (Decimal Degrees)? Thank you so much!
Thank you - just created a conversion of angles for my shadow calculations using your video with relative ease !!
Thanks,,but how you split the no. in the data option.. text... it was very fast didn't get it ... Thanks again
Thank you. Solution to a week of rescoped GPS cords.
How to do reverse of that
Thank you. This was a very quick easy and extremely helpful tutorial and a cinch compared to trying to manually convert multiples individually!
very good...it is very useful
thanks a lot, Sir! that's what i love about tech.
Thank you, keep it up. It helped me lot.
Thanks you sir😊😊😊
Huge thank you bro.
Thanks dude! Now I can sleep...
Really useful! Thanks
Very helpful. Thank you kind stranger.
Its very helpful thank you,sir...
Thank you man that is amazing help!
You saved me, THANKS!
glad to help.
hey #moulay_anwar.....i want to enter in the format cell the latitude and longitude and how to enter them correctly to covert them into decimal Please i want Fast reply for My own own work i want to finish it fast Furthermore, i want to add sybol to the lat/long like N Or W
It worked, thanks.
So helpful--thanks!
Thanks man, this was eZ thanks to you
great work, thanks a lot
Thank you, very well explained
thankyou very much شكرا كثيرا
Not able to see what is happening..
the video is blurry, can't see
Excellent video! thanks for posting.
Thank you!
Thank you so much!
it works on my computer but it doesnt on my friend's! anybody knows why? =(
thank you! Thank you! thank you!
very helpful thanky;u
Thank you very much
it helped very much)
Thank you for the help!
Thank You :)
very helpful, thx
😘😘😘 thanks
thank you brother
birilliant thank you
Lat long to utm please sir
nice. thanks.
THANKS
EX-EL-Ent!!!! Thank you!
nice
your formula doesn't account for South and East
I subtracted for the west, but for east just add instead. Use the formula for the north on the east and the formula from the west on the south and it will work for you.
Thank you very much
Thank you so much!