formatcurrency puts ( ) for negative numbers

[eddie wang]

formatcurrency function puts ( ) for negative numbers(e.g. (111) ). How
can I display the negative numbers with a minus sign infront like -111.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Curt_C [MVP]]

it's pulling this from the server's regional settings.

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"eddie wang" <ew***@kmg.com> wrote in message
news:uG*************@tk2msftngp13.phx.gbl...

formatcurrency function puts ( ) for negative numbers(e.g. (111) ). How
can I display the negative numbers with a minus sign infront like -111.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Aaron Bertrand - MVP]

You'll have to change the registry.

(Curt, changing regional settings for the current user, of course, will only
affect anything until the current user logs off.)

Or, use formatnumber() and a conditional... if it's less than zero, prepend
a -

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"eddie wang" <ew***@kmg.com> wrote in message
news:uG*************@tk2msftngp13.phx.gbl...

formatcurrency function puts ( ) for negative numbers(e.g. (111) ). How
can I display the negative numbers with a minus sign infront like -111.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Curt_C [MVP]]

well, whatta you know... guess I do learn something new all the time.
And here I was thinking, don't know why, that this was a global setting, not
a per-user.

Thanks for the clarification.

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:O2**************@TK2MSFTNGP11.phx.gbl...

You'll have to change the registry.

(Curt, changing regional settings for the current user, of course, will only affect anything until the current user logs off.)

Or, use formatnumber() and a conditional... if it's less than zero, prepend a -

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"eddie wang" <ew***@kmg.com> wrote in message
news:uG*************@tk2msftngp13.phx.gbl...

formatcurrency function puts ( ) for negative numbers(e.g. (111) ). How
can I display the negative numbers with a minus sign infront like -111.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!