[APBeta] AstroPlanner V2.0b104 released

[Ken Harrison]

Gary,
No, that's what I initially tried - reformat the cells to numbers....that
didn't work.
Jeff's solution did however work for me.(Thanks Jeff!!)
That was part of the pain...I just wanted to understand when the magnitude
column in AP was set to xx.xx why did it come across as xx.xxx???



On 5 April 2011 04:17, Gary A. Ferguson <garyfe at fergos.com> wrote:

>  I haven’t tried this at all, but even if it comes over as text, in Excel
> all you *should* have to do is right click the cells and select format
> text and then call it a number ( you can even select 2 digits after the
> decimal point at that time.)
>
>
>
> Gary
>
>
>
> *From:* apbeta-bounces at lists.astroplanner.net [mailto:
> apbeta-bounces at lists.astroplanner.net] *On Behalf Of *Ken Harrison
> *Sent:* Monday, April 04, 2011 4:44 PM
> *To:* AstroPlanner Beta Testers
> *Subject:* Re: [APBeta] AstroPlanner V2.0b104 released
>
>
>
> 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
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 6015 (20110404) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
> _______________________________________________
> 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/f74998b6/attachment-0002.htm>