negative number indication

QP9 sp4

While I have the pulpit, I just recalled another QP9 item I have been meaning
to ask the experts about.

Why will my QP not show negative numbers in ()?  Only with a minus sign.
In Tools; Settings; International I have "Parens" selected under
"Negative Values".  It doesn't work.  Right click on the title bar
and
select "application properties" gets me to the same
"settings" display.

If I enter "(5)" QP recognizes it as a negative and displays
"-5".

-- 
Rich Greenberg  N Ft Myers, FL, USA richgr atsign panix.com  + 1 239 543 1353
Eastern time.  N6LRT  I speak for myself & my dogs only.    VM'er since
CP-67
Canines:Val, Red, Shasta & Casey (RIP), Red & Zero, Siberians 
Owner:Chinook-L
Retired at the beach                                     Asst Owner:Sibernet-L

Rich Greenberg wrote:
> Why will my QP not show negative numbers in ()?  Only with a minus sign.
> In Tools; Settings; International I have "Parens" selected under
> "Negative Values".  It doesn't work.  Right click on the title
bar and
> select "application properties" gets me to the same
"settings" display.
> 
> If I enter "(5)" QP recognizes it as a negative and displays
"-5".

The General and Fixed numeric formats display as negative numbers, whereas 
Currency and Comma formats display with parentheses, given the international 
setting.

Cheers,
Uli

In article <47cfaed6_2@cnews>, Uli  <nojunkmail@spamless.com>
wrote:
>
>Rich Greenberg wrote:
>> Why will my QP not show negative numbers in ()?  Only with a minus
sign.
>> In Tools; Settings; International I have "Parens" selected
under
>> "Negative Values".  It doesn't work.  Right click on the
title bar and
>> select "application properties" gets me to the same
"settings" display.
>> 
>> If I enter "(5)" QP recognizes it as a negative and displays
"-5".
>
>The General and Fixed numeric formats display as negative numbers, whereas 
>Currency and Comma formats display with parentheses, given the international

>setting.

Ahhhh Soooooo.  Thanks Uli, I never realized that the little window that
opens for "number" & "curency" controlled this.  Now I
see it.

So the settings dialog In Tools; Settings; International doesn't do
anything.  But what is "Comma format"?  I don't see that.

-- 
Rich Greenberg  N Ft Myers, FL, USA richgr atsign panix.com  + 1 239 543 1353
Eastern time.  N6LRT  I speak for myself & my dogs only.    VM'er since
CP-67
Canines:Val, Red, Shasta & Casey (RIP), Red & Zero, Siberians 
Owner:Chinook-L
Retired at the beach                                     Asst Owner:Sibernet-L

Rich Greenberg wrote:
> In article <47cfaed6_2@cnews>, Uli  <nojunkmail@spamless.com>
wrote:
>> The General and Fixed numeric formats display as negative numbers,
whereas 
>> Currency and Comma formats display with parentheses, given the
international 
>> setting.
> 
> Ahhhh Soooooo.

Looks like your "h" and "o" keys are a little sticky, but I
think I'm able to 
hear an "Ach so!"  :-)

> So the settings dialog In Tools; Settings; International doesn't do
> anything.

Actually, it does.  If you change the international currency setting for 
negative values from "Parens" to "Signed", the currency
format will display your 
negative amounts as -$x.xx  (Set the numeric format to currency, then fiddle 
with the international currency setting to observe the effect.)

> But what is "Comma format"?  I don't see that.

That's one of the numeric formats in v8 -- apparently, that doesn't exist 
anymore in v9.  The comma format inserts a thousands separator where needed. 
Perhaps in v9 that format was incorporated as an option into the Fixed format, 
similar to how it's done in Excel.

Cheers,
Uli

In article <47d08620_3@cnews>, Uli  <nojunkmail@spamless.com>
wrote:

>> So the settings dialog In Tools; Settings; International doesn't do
>> anything.
>
>Actually, it does.  If you change the international currency setting for 
>negative values from "Parens" to "Signed", the currency
format will
>display your 
>negative amounts as -$x.xx  (Set the numeric format to currency, then fiddle

>with the international currency setting to observe the effect.)

OK

>> But what is "Comma format"?  I don't see that.
>
>That's one of the numeric formats in v8 -- apparently, that doesn't exist 
>anymore in v9.  The comma format inserts a thousands separator where needed.

>Perhaps in v9 that format was incorporated as an option into the Fixed
format, 
>similar to how it's done in Excel.

That is the case.  There is a check box for "use 1000 seperator".

Thanks.

-- 
Rich Greenberg  N Ft Myers, FL, USA richgr atsign panix.com  + 1 239 543 1353
Eastern time.  N6LRT  I speak for myself & my dogs only.    VM'er since
CP-67
Canines:Val, Red, Shasta & Casey (RIP), Red & Zero, Siberians 
Owner:Chinook-L
Retired at the beach                                     Asst Owner:Sibernet-L