Computer Science, asked by parthprajapati6801, 11 months ago

How to convert degree minute second to degree decimal in excel

Answers

Answered by sehangshu22
0

Converting Decimal Degrees to Degrees/Minutes/Seconds

Start Excel and press ALT+F11 to start the Visual Basic editor.

On the Insert menu, click Module.

Enter the sample code for the Convert_Degree custom function described above into the module sheet.

Press ALT+F11 to return to excel.

In cell A1 type 10.46.

Similar questions