[APBeta] AstroPlanner V2.0b104 released

[Jeff & Kathy Lowrey]

Hi Ken,

Go to the Excel Help menu and search for "convert text to number". This 
shows a fairly straightforward way to convert a column (or a single 
cell) imported as text back to numbers that you can work on in the 
normal way.
I have tested it!  It's one quick and easy solution.

Regards
Jeff


On 5/04/2011 9:13 AM, Ken Harrison wrote:
> Hmmm
> When the magnitude column is transferred to Excel it comes over as 
> text rather than number format -I can't seem to do anything with it 
> other than re-type of the data - hence the cry for help.
> ken
>
>
> On 5 April 2011 00:06, Paul Rodman <paul at ilanga.com 
> <mailto:paul at ilanga.com>> wrote:
>
>
>     On Apr 4, 2011, at 5:47 AM, Ken Harrison wrote:
>
>     > Need some help!
>     > On the latest 104 release I have a 2000 Be star database and I'm
>     trying to export to an excel spreadsheet the "top 50" -The
>     original data base had magnitudes formatted in xx.xxx but I only
>     need xx.xx for this spreadsheet.
>     > I've reformatted the magnitude column (edit/ list/ columns/
>     format) and even set it to the default (i've also checked the XL
>     export seetings.txt file)
>     > It still seems to export the magnitudes to three decimal places!!!
>     > How do I get it to revert to xx.xx????
>     > I've saved and restarted a few times with the same results.
>
>     I don't know if that's controllable. Can't you just format the
>     Magnitude column in Excel to have two decimal places?
>
>     Paul R.
>
>
>     _______________________________________________
>     APBeta mailing list
>     APBeta at lists.astroplanner.net <mailto:APBeta at lists.astroplanner.net>
>     http://lists.astroplanner.net/listinfo.cgi/apbeta-astroplanner.net
>
>
>
>
> -- 
> "Astronomical Spectroscopy - The Final Frontier" - to boldly go where 
> few amateurs have gone before....
> http://tech.groups.yahoo.com/group/astronomical_spectroscopy/?yguid=322612425
> "Astronomical Spectroscopy for Amateurs" - Springer
>
>
> _______________________________________________
> APBeta mailing list
> APBeta at lists.astroplanner.net
> http://lists.astroplanner.net/listinfo.cgi/apbeta-astroplanner.net