Urgent please help

A

Absynth

I have to conevert a column of data in excel from degrees minute seconds
(DMS) to decimal degree.. And excel only accepts data in form of dd mm ss and
my data is in format ddmmss.. theres just too much data to do it manually..
Can anyone help me find any function which allows to insert spaces in my
format.
Thanks..
 
G

Gary''s Student

Say A1 has:
451215
meaning 45 degrees, 12 minutes, 15 seconds. In B1 enter:

=LEFT(A1,2)+MID(A1,3,2)/60+RIGHT(A1,2)/3600
to display:

45.20416667
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
DMS to degree conversion in excel 1
Converting decimal degrees to degrees, minutes & seconds 2
Creating a Search using a combo box and then creating a report. 4
How to enter a date in DD-MM-YYYY format 2
Please help me choose a product for the task 2
Publisher is filling blank lines with data 2
using macro in form to convert XY coordinates 1

Top