![]() |
|
#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. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2007 cell format help!!!
|
Raner | Excel | 4 | 06-17-2013 11:13 PM |
Excel convert format [h]:mm:ss to decimal
|
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 |
Format Excel to look like Word
|
Kilconey | Excel | 1 | 04-30-2010 09:42 AM |