Closed Thread
Results 1 to 4 of 4

Brackets or paranthesis around negative numbers in Excel

  1. #1
    Lorne
    Guest

    Brackets or paranthesis around negative numbers in Excel

    Does Excel have a format?

  2. #2
    Bernard Liengme
    Guest

    Re: Brackets or paranthesis around negative numbers in Excel

    Try Custom format #,##0;(#,##0)

    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Lorne" <Lorne@discussions.microsoft.com> wrote in message
    news:221C26C5-E342-4CE4-AC8F-3E158E3EF995@microsoft.com...
    > Does Excel have a format?




  3. #3
    SVC
    Guest

    RE: Brackets or paranthesis around negative numbers in Excel

    Format > Cell , on the Number tab select Number and choose the negative
    number format.

    You can also use Format, Cell and on the Number tab select Accounting.

    "Lorne" wrote:

    > Does Excel have a format?


  4. #4
    Lorne
    Guest

    Re: Brackets or paranthesis around negative numbers in Excel

    Thanks Bernard. I'm new and you and Dav have opened a new door in Excel for
    me.


    "Bernard Liengme" wrote:

    > Try Custom format #,##0;(#,##0)
    >
    > --
    > Bernard V Liengme
    > www.stfx.ca/people/bliengme
    > remove caps from email
    >
    > "Lorne" <Lorne@discussions.microsoft.com> wrote in message
    > news:221C26C5-E342-4CE4-AC8F-3E158E3EF995@microsoft.com...
    > > Does Excel have a format?

    >
    >
    >


Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1