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.(This inserts the degree symbol-and you must use 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. Excel displays the Format Cells dialog box. 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.