formatcurrency puts ( ) for negative numbers

Discussion in 'ASP General' started by eddie wang, Feb 11, 2004.

  1. eddie wang

    eddie wang Guest

    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!
    eddie wang, Feb 11, 2004
    #1
    1. Advertising

  2. 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" <> wrote in message
    news:...
    > 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, Feb 11, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jack

    Error with formatcurrency statement

    Jack, Oct 21, 2004, in forum: ASP General
    Replies:
    3
    Views:
    127
    Ray Costanzo [MVP]
    Oct 22, 2004
  2. Replies:
    3
    Views:
    110
    Mark D Powell
    Aug 17, 2005
  3. ljb
    Replies:
    5
    Views:
    119
    Aaron Bertrand [SQL Server MVP]
    May 11, 2006
  4. Michael Brooks
    Replies:
    22
    Views:
    385
    Rick DeNatale
    Mar 27, 2007
  5. Raj Singh
    Replies:
    4
    Views:
    132
    Ryan Ingram
    Jan 29, 2008
Loading...

Share This Page