Urgent please help

  • Thread starter Thread starter Absynth
  • Start date Start date
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..
 
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

using macro in form to convert XY coordinates 1
How to enter a date in DD-MM-YYYY format 2
Excel Macro to copy a row to another sheet based on date 0
Geographical coordinates 3
How to import data 3
Formatting cells as degrees? 1
VINAY DALMIA 2
Advanced filtering in Excel 0

Back
Top