Places that I need to go to are given to me in GPS coordinates. I use a batch parameter query to recall those locations and give me their corresponding GPS locations.
Sometimes, they don't have them and I have to look at the paperwork to get it... That's ok.
Since the recall query extracts the GPS coordinates in decimal degrees (40.446, -79.982), that's what I go with.
When it isn't provided for me, the paper work gives it to me in degrees minutes seconds (40° 26′ 46″, -79° 58′ 56″). That's ok
I input the degrees minutes seconds values in some conversion formula I made in K9, L9, and M9 for North, and K10, L10, and M10 for West.
N9 and N10 will give the the converted values back to the decimal degrees that I need.
Having said this, when i want to copy and paste THOSE VALUES from N9 and N10, I ALWAYS HAVE TO right click and PASTE VALUE.
Is there a way for me to Ctrl+V (Paste) without having to right click? If No, can I use a O9 and O10 formula to just copy what's on N9 & N10 and it will only copy the values and not the formulas?
I want to avoid the step of ALWAYS HAVING TO RIGHT CLICK to get "Paste Value".
I broke down the GPS formula (Degrees Minutes Seconds) in a couple of cells. I need the DMS value in just decimals, and one of my cells converts that.
Bookmarks