ExcelBanter - Converting Decimal Degrees to Degrees/Minutes/Seconds

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Converting Decimal Degrees to Degrees/Minutes/Seconds (https://www.excelbanter.com/excel-worksheet-functions/247263-converting-decimal-degrees-degrees-minutes-seconds.html)

Larry_Klotz

Converting Decimal Degrees to Degrees/Minutes/Seconds

I wish to find the commands in Excel to convert Decimal Degrees to
Degrees/Minutes/Seconds and the reverse. Thank you.

Gord Dibben

Converting Decimal Degrees to Degrees/Minutes/Seconds

See Chip Pearson's site for instructions.

http://www.cpearson.com/excel/latlong.aspx

Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 11:06:09 -0800, Larry_Klotz
wrote:

I wish to find the commands in Excel to convert Decimal Degrees to
Degrees/Minutes/Seconds and the reverse. Thank you.

All times are GMT +1. The time now is 03:07 PM.