| Date: | Tue, 9 Feb 1999 11:09:06 -0600 |
| Reply-To: | stevenp@greatorganizations.com |
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU> |
| From: | Steven M Palmer <stevenp@GREATORGANIZATIONS.COM> |
| Subject: | Re: Possibly useful work around |
|
| In-Reply-To: | <36b5bec5.3108006@news.umsl.edu> |
| Content-Type: | text/plain; charset="iso-8859-1" |
Which versions of Excel and SPSS are you using? I use SPSS version 8.02 and
Excel versions 97 (service release 2) and Excel 2000.
I too have been doing the SPSS>Excel>Word>Exec>etc. thing for the last
decade in order to do more useful write-ups of work, and have no problems at
all with notation, etc.. (Although it would be nice to be able to run
syntax directly from Excel...)
Steven M. Palmer
Partner
The Center for Organization Effectiveness
StevenP@GreatOrganizations.com
www.GreatOrganizations.com
608-833-3332 x:28
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@UGA.CC.UGA.EDU] On Behalf Of
jpwinter@UMSL.EDU
Sent: Monday, February 01, 1999 8:54 AM
To: SPSSX-L@UGA.CC.UGA.EDU
Subject: Re: Possibly useful work around
I do the SPSS->Excel->word processor waltz when I am doing a write-up.
WordPerfect can read old Excel spreadsheets, so I save them in Excel
and insert them in WP.
Does anyone still have problems with the scientific notation in Excel?
I found that Excel doesn't automatically replace notation numbers with
regular decimals.
My workaround: Do a find and replace on "E" -- after Excel performs
this operation, the numbers convert to regular decimal.
Just thought I'd share my piece.
|