| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I work with part of a cell entry?
I have columns of numbers representing degrees,minutes and decimal minutes
with the format xxxx.xxx where the forst two digits to the left are degrees and the last five are minutes and decimal minutes. I am using these in another program that only accepts degrees and decimal degrees. I just wish to divide the last five digits representing minutes by 60 to get decimal degrees. My columns can be up to 800 cells long so I would like to establish a range for the conversion. I am using Excel 2003. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need help with an "If" Statement | Excel Worksheet Functions | |||
| Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) | |||
| how do I use a cell value as part of a cell refereren in a formula | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
Threaded Mode
