And thank you, Alex, for posting the solution in such detail. Far too often, people who figure out the answer to their own question either say nothing at all, or post something like, "Never mind...I figured it out!" Your post is a great example of what people ought to do when they figure out the answer to a question they posted. Cheers!
Alex Huang wrote
Dear List,
I have figured out the solution to this problem myself and would like to share this with you.
The behavior can be changed, no matter SPSS 19 or later version, by checking the option to include footnotes and captions during the export to Excel. It is exactly:
Click File - Export - Change Options - check the option "Include footnotes and captions" - OK.
ref:
http://www-01.ibm.com/support/docview.wss?uid=swg1PM42210Regardless, I thank everyone who may have been thinking about the solution for me.
Thanks,
Alex
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/"When all else fails, RTFM."
PLEASE NOTE THE FOLLOWING:
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (
https://listserv.uga.edu/).