[APBeta] AstroPlanner V2.0b104 released

[Paul Rodman]

Send me the spreadsheet privately and I'll render an opinion...

Paul R.

On Apr 4, 2011, at 4:43 PM, 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> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.astroplanner.net/pipermail/apbeta-astroplanner.net/attachments/20110404/0581b140/attachment-0003.htm>