Type a space, mm, an apostrophe, another space, ss, and two more apostrophes.Type followed by a degree sign (remember you hold down the Alt key and type 0176 on the numeric keypad).Excel displays the Format Cells dialog box. Select the cell containing the formula.Then you can format the display of the formula as follows: If you want to use a display instead, you can simply divide the decimal value of the latitude or longitude by 24, which converts it into the same value ranges used by Excel to represent times. The result is text, and cannot be used in any calculations. This is a long formula, but it provides the desired formatting of the latitude or longitude value. For instance, if 122.44 is in cell A7, then you can put the following in cell B7: Instead, you must use a formula to achieve the proper display. This cannot be accomplished with formatting the cell in which the number is contained. For instance, you may want 122.44 (which is a decimal representation of degrees) to be displayed as 122 degrees, 26 minutes, and 24 seconds. Sometimes, however, you may want to take a decimal value that represents latitude and longitude and display it in degrees, minutes, and seconds. Now, if you type a number such as 1234543 into the cell, it is displayed as 123 degrees, 45 minutes, and 43 seconds.

(A quote mark won't work it must be two apostrophes.)

Type two more zeros followed by two more apostrophes.

Type a space, two zeros, an apostrophe (the single quote), and another space.

If you don't have a numeric keypad, you need to enable the Num lock before using the Alt 0176 keyboard shortcut.) (The numbers must be typed on the numeric keypad. Hold down the Alt key and type 0176 on the numeric keypad.Place the insertion point in the Type box and erase whatever is there.The Number tab of the Format Cells dialog box. In the categories list, choose Custom.

Select the cell you want to format for latitude or longitude.There are three ways that a solution can be approached.įirst, if you just want to affect the display, you can follow these steps: If you do much geographic work, you may wonder if you can use Excel to display longitude and latitude in a cell in terms of degrees, minutes, and seconds.

Utm To Decimal Degrees Converter Excel