excel latitude and longitude conversion formula

excel longitude and latitude conversion formula

1. First, create a new Excel table and put ( ° ′ ″) format longitude and latitude input form.

2. Then click on the cell where you want the conversion to be stored. , enter the following formula in the fx formula position, as shown in the figure =MID(B2,2,2) MID(B2,5,2)/60 MID(B2,11,2)/3600

3. Then the decimal coordinates you want appear in the D1 grid.

##4. Place the mouse on the cell. When a wide cross appears, move down. Then all (° ′ ″) format coordinates in cell A will be converted into decimal format.

5. If you copy and paste the converted data directly, an error will occur, as follows

6. Below, you select the data, then find the table you want to paste, right-click the mouse as follows

7. Find Paste Special, click and the following appears Situation

8. Select the value and then paste it. You will not go wrong. As follows

Recommended tutorial:

excel tutorial

The above is the detailed content of excel latitude and longitude conversion formula. For more information, please follow other related articles on the PHP Chinese website!