Latitude & Longitude

To Calculate Lat & Long in Excel

Formula for Degree Decimals to Deg Min Sec

Example: 1.2267 in C2
Get it in 1 cell, enter formula, =TEXT(C2/24,"[h]° mm' ss'' ")
Get it in 3 diff cells, enter as follows
for Degrees, =INT(C2)
for Minutes, =MINUTE(C2/24)
for Seconds, =SECOND(C2/24)

Formula for Deg Min Sec to Degree Decimals

If in 3 Different Cells,
Example: 1° in C1, 13' in D1, 36" in E1
Enter Formula, =C1 + D1/60 + E1/60/60

Roman Numerals

Roman numerals are written using the seven letters of the alphabet (shown in Table)

There are certain rules when using Roman numerals:

Letters are arranged from the largest to smallest.

Numbers are added to arrive at the value.

• For example XVI is X (10) +V (5) + I (1) = 16.

When a smaller number precede a larger number, the smaller is subtracted from the larger.

• For example: IX is 1 (I) subtracted from 10 (X) = 9.

Roman Numeral	Number
I	1
V	5
X	10
L	50
C	100
D	500
M	1000

For bigger number, i.e ≥ 5K, an overbar is used

Blank Cells

Fill Blank Cells of Title Cell

To fill blank cells
Steps as follows:

• Find blank cells using Go To Special [Find & Select, Editing, Home Tab]
• When blank cells selected Press Ctrl Key
• Enter =above cell [e.g. =A1] in formula bar
• Press Ctrl + Enter