![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
Hi guys. I'm stuck on a really annoying problem at the moment.
Basically, I've been tracking the positions of a number of asteroids over the last 2 months and using a program to output the RA and Dec of the asteroid relative to it's position to the other stars in the sky. Now so far I've been inputting the RA and Dec's in the following format into an Excel spreadsheet: 00 03 34.43 Now I'm in a bit of predicament because I need to start playing about with this data, so I need it in decimal form (i.e. 0.00054°) (note these are completely random values I've giving ![]() I've been using spaces to separate the degrees, arc minutes and arc seconds, Excel will not read the values as actual numbers and just the cells as a zero. Does anyone know of anyway that I could somehow get Excel to insert colons into the two spaces, or get it to recognise numbers written in this format? Kind Regards, Matt |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Decimalising RA and Dec Values | Matt | Amateur Astronomy | 17 | November 26th 06 08:43 PM |
Help with values on astro equipment | Keith | Amateur Astronomy | 9 | June 25th 06 10:13 AM |
Looking for table with values for combined MK rotation curve | canopus56 | Amateur Astronomy | 0 | February 21st 06 12:36 AM |
Values | Twittering One | Misc | 1 | January 7th 05 07:24 AM |
Obtaining other values from NASA 2-Line Element | Ray Williams | Satellites | 8 | July 22nd 03 03:44 PM |