A Space & astronomy forum. SpaceBanter.com

Go Back   Home » SpaceBanter.com forum » Others » Misc
Site Map Home Authors List Search Today's Posts Mark Forums Read Web Partners

Decimalising RA and Dec Values



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old November 23rd 06, 11:29 PM posted to sci.astro.amateur,microsoft.public.excel.programming,uk.sci.astronomy,alt.astronomy
Matt
external usenet poster
 
Posts: 42
Default Decimalising RA and Dec Values

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 ). However, because
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 04:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 SpaceBanter.com.
The comments are property of their posters.