Most valuable professional
  • Hot Topics

Excel DMS to Decimal Degree

I have read several posts on here relating to this topic but for some reason I have been unable to get the formulas provided in the other posts to work for the particular format I am working with. I guess I am just mentally seized up today. I apologize for having to repost a topic that has already been gone over several time. The format I am working with is 4114'36" -7651'46" and I need to have it report in 41.24326 -76.86277 The Lat will always be positive and the Long will always be negative. I would like to have this done in a single cell and not split up over 3. Thanks Last edited by MJL5043; Yesterday at 03:42 PM.

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of December 16, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel