[APBeta] AstroPlanner V2.0b104 released

[Ken Harrison]

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> 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
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.astroplanner.net/pipermail/apbeta-astroplanner.net/attachments/20110405/dbe642a1/attachment-0003.htm>