•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 426,974 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,413 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 2111 | Replies: 5
 |
•
•
Join Date: Sep 2005
Posts: 16
Reputation: 
Rep Power: 4
Solved Threads: 0
Newbie Poster
Is it possible to format a cell so that an angle in degrees can be shown as an angle in degrees minutes and seconds? Any help would be much appreciated...
•
•
Join Date: Nov 2005
Location: Montreal, QC (Almost)
Posts: 130
Reputation:
Rep Power: 3
Solved Threads: 9
Junior Poster
Hi grandfilth,
I tried to format a control for degrees minutes and seconds and, just like you, could not do it. So I made these two little routines that will do the job for you, one converting from decmal degrees to degrees, minutes and seconds and the other converting back to decimal degrees.
Remember that this is a 20 min job so everything might not be perfect.
Hope this helps
Yomet
I tried to format a control for degrees minutes and seconds and, just like you, could not do it. So I made these two little routines that will do the job for you, one converting from decmal degrees to degrees, minutes and seconds and the other converting back to decimal degrees.
Remember that this is a 20 min job so everything might not be perfect.
Hope this helps
Yomet
•
•
Join Date: Sep 2005
Posts: 16
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
just found this, its quite neat...
http://www.cpearson.com/excel/latlong.htm
http://www.cpearson.com/excel/latlong.htm
•
•
Join Date: Nov 2005
Location: Montreal, QC (Almost)
Posts: 130
Reputation:
Rep Power: 3
Solved Threads: 9
Junior Poster
Cool page, thanks for the link.
Yomet
Yomet
•
•
Join Date: Jul 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Can i use this in excel 2003 and if so how?
•
•
Join Date: Nov 2005
Location: Montreal, QC (Almost)
Posts: 130
Reputation:
Rep Power: 3
Solved Threads: 9
Junior Poster
Andrew,
I don't see why you could not use it in XL 2003. Just copy-paste the two conversion functions into a module and then call them from the spreadsheet.
I tested it in the attached spreadsheet (XL 2000), remember to check your macro security settings.
Yomet
I don't see why you could not use it in XL 2003. Just copy-paste the two conversion functions into a module and then call them from the spreadsheet.
I tested it in the attached spreadsheet (XL 2000), remember to check your macro security settings.
Yomet
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- I just get six seconds of on time (Troubleshooting Dead Machines)
- Urgent help needed (Pascal and Delphi)
- -NaN message (C)
- My log of annoingness (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Printing in a usb port
- Next Thread: Codes for excel
