Create your own formula to convert the degrees, minutes and seconds used in geography to a decimal number. DMS map coordinates consist of whole number degrees that are divided into 60 minutes.

Warnings Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

This tutorial will show you how to change the number of Decimal places in Microsoft Excel using any one of these 3 methods.

Can Excel do that? A. Sure can, and here’s how it’s done: Highlight the decimal numbers you want to convert to fractions and then right-click, selecting Format Cells and the Number tag.