![]() |
#7
|
|||
|
|||
![]()
If cell E19 is 78.359272 in degrees decimal then:
CONCATENATE(TEXT(INT(E19),"##° "),TEXT(INT((E19-INT(E19))*60),"##'"),TEXT(MOD((E19-INT(E19))*60,INT((E19-INT(E19))*60))*60,"##.##"),"""") Will return: 78° 21' 33.38" It may seem complicated but it give the exact format to put in to Google Earth or similar software. U can do all your calculations in decimal. If u use radians u must convert to degrees before applying the formula. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Raner | Excel | 4 | 06-17-2013 11:13 PM |
![]() |
gchan2000 | Excel | 1 | 08-17-2010 01:36 PM |
Updating excel link alters table format in PP | dbmagnus | PowerPoint | 0 | 06-03-2010 12:12 PM |
Need help in format or link in excel | handsome1968 | Excel | 1 | 05-01-2010 09:20 AM |
![]() |
Kilconey | Excel | 1 | 04-30-2010 09:42 AM |