scientific notation in output - large numbers, not small!

[maiya]

Hi!

I've given up googling this and need help!

I'm getting output (e.g. a sum over a variable) in scientific notation: 1.72E8.

I am aware of the Option "No scientific notation for small numbers in tables", but these are large numebr not small!

I'm also aware that if I rightclick on the table and go th Cell Properties| Format Value and choose e.g. Number | #,###.## I get the desired 171,574,092.43 in this case.

But is there any way of making this output format the default?

Your help will be greatly appreciated!

Maja.

[Heidi Green]

Hello-
I had a similar post to the list a while back, and I don't believe I
ever received a response either...every month when I run a certain
project with large numbers, I have to double click my output table to
edit it and drag the column larger. Then the exponential notation
automatically changes. It is a workaround, but still not as convenient
as having the number display properly right away.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
maiya
Sent: Saturday, February 27, 2010 1:45 PM
To: [hidden email]
Subject: scientific notation in output - large numbers, not small!

Hi!

I've given up googling this and need help!

I'm getting output (e.g. a sum over a variable) in scientific notation:
1.72E8.

I am aware of the Option "No scientific notation for small numbers in
tables", but these are large numebr not small!

I'm also aware that if I rightclick on the table and go th Cell
Properties|
Format Value and choose e.g. Number | #,###.## I get the desired
171,574,092.43 in this case.

But is there any way of making this output format the default?

Your help will be greatly appreciated!

Maja.


--
View this message in context:
http://old.nabble.com/scientific-notation-in-output---large-numbers%2C-n
ot-small%21-tp27731219p27731219.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

----------------

Defender MX2 - QLAN

=====================
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

[Richard Ristow]

At 04:44 PM 2/27/2010, maiya wrote:

I'm getting output (e.g. a sum over a variable) in scientific notation:
1.72E8.

I'm aware that if I rightclick on the table and go the Cell Properties|Format Value and choose e.g. Number | #,###.## I get the desired 171,574,092.43 in this case.

Syntax command

SET FORMAT(COMMA17.2).

will give new numeric variables, by default, the display format you want. However, to see that in the data editor you'll need to expand the column width (see command VARIABLE WIDTH); and, regrettably, there isn't a SET option for that.

After the variables are created, you can use syntax command

VARIABLE WIDTH ALL (17).

(Try different width values; because of font size differences, etc., some value less than 17 may work.)

You can use command

FORMATS ALL(COMMA17.2).

if all your variables are numeric. (Query: I thought there was a form of 'varlist' to denote "all numeric variables"; but if so, I can't find it.)

And if only some of your variables, say BigVal1 to BigVal17, need to be formatted that way, you can use syntax commands

FORMATS BigVal1 to BigVal17(COMMA17.2).
VARIABLE WIDTH BigVal1 to BigVal17 (17).

-Best wishes to you,
 Richard
===================== 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

[ViAnn Beadle]

Set your minimum column width in a table look to something larger than the
default and then use that table look for the tables that tend to go to
scientific notation. Follow help for additional details.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Heidi Green
Sent: Tuesday, March 02, 2010 3:28 PM
To: [hidden email]
Subject: Re: scientific notation in output - large numbers, not small!

Hello-
I had a similar post to the list a while back, and I don't believe I ever
received a response either...every month when I run a certain project with
large numbers, I have to double click my output table to edit it and drag
the column larger. Then the exponential notation automatically changes. It
is a workaround, but still not as convenient as having the number display
properly right away.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
maiya
Sent: Saturday, February 27, 2010 1:45 PM
To: [hidden email]
Subject: scientific notation in output - large numbers, not small!

Hi!

I've given up googling this and need help!

I'm getting output (e.g. a sum over a variable) in scientific notation:
1.72E8.

I am aware of the Option "No scientific notation for small numbers in
tables", but these are large numebr not small!

I'm also aware that if I rightclick on the table and go th Cell
Properties|
Format Value and choose e.g. Number | #,###.## I get the desired
171,574,092.43 in this case.

But is there any way of making this output format the default?

Your help will be greatly appreciated!

Maja.


--
View this message in context:
http://old.nabble.com/scientific-notation-in-output---large-numbers%2C-n
ot-small%21-tp27731219p27731219.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

----------------

Defender MX2 - QLAN

=====================
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

=====================
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