how to insert degrees, minutes, seconds into cell

K

kwitty

New Member
Joined
Dec 28, 2007
Messages
9
I'm doing a project for work that requires lat and long. It isn't a big deal if I were to enter the number as 351724.11548, but I just thought it would look better and be easier to read if it had the degrees, minutes, and seconds symbols after the numbers. Thanks in advance for any help!
 
Sort by date Sort by votes
The first solution by bolandd is the one that works for me except for the negative latitudes. Since excel thinks it's hours and it does not allow negative time. Hoe to get around that?
 
Upvote 0

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You must log in or register to reply here.

Similar threads

R
  • Question
Insert new rows based on user input
Replies
0
Views
131
remmuS24
R
B
  • Solved
Need to add two sets of minutes with custom formatting and round
Replies
1
Views
77
bh24524
B
P
  • Solved
Advice needed on where to put code that stops duplicate entries
Replies
5
Views
355
Pacman52
P
N
  • Question
Stacked Chart to show value and status YTD
Replies
2
Views
396
neilo1969
N
A
  • Question
How to search for matching data and return result from a cell?
Replies
9
Views
456
Arinoum
A

Forum statistics

Threads
1,215,900
Messages
6,127,640
Members
449,394
Latest member
fionalofthouse

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top