Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Negative Numbers in Brackets (Excel 2000 SP2)

    I have NT4 SP5 (English and German) on two PCs with English Office. The regional settings negative numbers are set to appear in brackets, however when I enter a negative number (the cell is formatted as a number) it returns the number as a -1234 rather than (1234). How can I get negative numbers in Excel to appear in brackets.

    All hope much appreciated.

    Regards

    John

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Negative Numbers in Brackets (Excel 2000 SP2)

    Hi John,
    You can use a custom number format for this - personally I use this one:
    #,##0.00_);[ Red](#,##0.00);0.00
    which keeps all the numbers aligned at the decimal point but you can amend it for your needs as necessary. (note I've had to add a space between [ and Red to stop the Lounge from treating it as a markup tag)
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Negative Numbers in Brackets (Excel 2000 SP2)

    Hi Rory,

    It must be me (one of those days!). I have tried this but nothing seems to happen, forgive my ignorance here, Excel is not my hottest application.

    I insert a number, goto format cells select custom format, select the format you mentioned but the number format remains the same, am I missing a step?

    Regards

    John

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Negative Numbers in Brackets (Excel 2000 SP2)

    John,
    That should be all you need to do. Are the cells formatted as text initially? That would cause the behaviour you describe. If not, can you attach a copy of a small workbook that exhibits this behaviour?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •