degrees minutes seconds number format code?!!

stark

New Member
Joined
Dec 28, 2005
Messages
2
i have a question:
when i import my text file into excel it shows the degrees as 32.245563223 (this is NOT decimal degrees...it is degrees minutes seconds)

i need it to be displayed like this: 32°24'55.6"

what would the number format code be to show this?

can you please help...

thanks,
stark
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

stark

New Member
Joined
Dec 28, 2005
Messages
2
thanks...

when i enter the code [hh]°mm'ss\" it turns my latitude from: 31.295530155
to: 751°05'34"
instead of 31°29'55.3"

any ideas as to what could be wrong?

thanks again,
stark
 

MPBotti

New Member
Joined
Jan 4, 2006
Messages
6
Hi Stark,

To fix that problem, I prefer to use a custom format as ##° ##' ##.0000\" \S.

Suerte,
 

jkeohane

New Member
Joined
Mar 2, 2017
Messages
2
Alas I have tried this many times, and I have not succeed in simply displaying the number this way. It really should be built into Excel.

I simply put the degrees, minutes, and seconds in different cells. Then I make another cell called something like decimal degrees, and I just add them up and divide by the appropriate factors of 60. If you have a data file, I guess you need to either figure out how to import them separately, or understand what it is doing wrong.

In Stark's example above, you would simply use the MOD() function to separate this into three different cells, and then put them back together again.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,589
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Maybe in a separate cell multiply by 10000 and custom format as 0º 00' 00.0''

Book1
AB
132.2455632232º 24' 55.6''
Sheet1
Cell Formulas
RangeFormula
B1B1=A1*10000
 

Watch MrExcel Video

Forum statistics

Threads
1,118,286
Messages
5,571,313
Members
412,382
Latest member
Langtn02
Top