I'm exporting a lot of files to Excel and was wondering if I could change the
default format of storing "numbers as text" to "numbers" in the syntax of
SPSS?
An example of the syntax I'm using is below.
OUTPUT EXPORT
/CONTENTS EXPORT=VISIBLE LAYERS=PRINTSETTING MODELVIEWS=PRINTSETTING
/XLS DOCUMENTFILE=
OPERATION=CREATESHEET SHEET=
LOCATION=LASTCOLUMN NOTESCAPTIONS=YES.
Regards,
Ust Oldfield
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
