J
JKB
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?
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?