| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Degrees/Minutes/Seconds to Decimal Degrees
You don't have to call the other functions. The main one
Convert_Decimal calls the other ones -- GetNum, LopText, and LopNum. The names are descriptive. Take your example "12deg03min00sec". GetNum grabs the "12". LopNum lops it off, leaving "deg03min00sec". LopText lops "deg", leaving "03min00sec". GetNum grabs the "03". And so forth. Identifying a character as a number or not utilizes the function Asc( ). Asc(48)-Asc(57) are the digits 0-9. Merjet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Decimal Degrees to Degrees/Minutes/Seconds | Excel Worksheet Functions | |||
| How do you convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| how can i convert degrees/minutes/seconds to decimal degrees? | Excel Discussion (Misc queries) | |||
| convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Threaded Mode
