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

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!