[wasyoungonce (Brendan)]

Originally Posted by glenc

If you want hms and dms see here:http://www.iceinspace.com.au/forum/s...ad.php?t=38919

Thanks, I don't really need the conversions, I applied my own DD to DMS conversions using my Macros way back when there was a list for 100 Brightest Southern Objects (in the Articles page). But this has all now now changed to 100Galaxys, 111Brightest NGC objects etc.

The original data had coordinates in Decimal Degrees so I played around with Macros to convert these to DMS.

Here is a typical example of the formula (in the 2nd column) converting DEC DD to DMS:

Edit...my post went funny so I uploaded a excel sheet with formulas.

Edit:

grumble I keep mucking the upload up...finally here it is in Zip.