[APBeta] AstroPlanner V2.0b104 released

[Gary A. Ferguson]

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=32261242
5
"Astronomical Spectroscopy for Amateurs" - Springer

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