+ Reply to Thread
Results 1 to 8 of 8

Negative numbers in parenthesis if not shown in drop down box

  1. #1
    Pandorad
    Guest

    Negative numbers in parenthesis if not shown in drop down box

    How do I get negative numbers in brackets if <Format<Cells<Numbers drop down
    box does not show negative numbers in parenthesis. My spreadsheet shows
    negative numbers with a '-' minus sign.

    Thank you
    Sheron

  2. #2
    Alan
    Guest

    Re: Negative numbers in parenthesis if not shown in drop down box

    Try custom formatting
    #,##0;"("#,##0")"

    to display a negative value as (20) or
    #,##0;-"("#,##0")"
    to display -(20)
    Regards,
    "Pandorad" <Pandorad@discussions.microsoft.com> wrote in message
    news:D6540186-77AC-4047-AFC5-E0AB3C4B6684@microsoft.com...
    > How do I get negative numbers in brackets if <Format<Cells<Numbers drop
    > down
    > box does not show negative numbers in parenthesis. My spreadsheet shows
    > negative numbers with a '-' minus sign.
    >
    > Thank you
    > Sheron




  3. #3
    Gord Dibben
    Guest

    Re: Negative numbers in parenthesis if not shown in drop down box

    Sheron

    If bracketed negatives are not available in Format>Cells>Number.....

    This is a function of your Regional Settings in Windows OS.

    Start>Settings>Control Panel>Regional and Language Settings>Regional
    Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
    and select the ($1.1)

    Apply and OK>Apply your way out.

    You will have to close Excel then re-open to see effects.

    You will then be able to choose that format.


    Gord Dibben Excel MVP

    On Sat, 30 Apr 2005 06:08:02 -0700, "Pandorad"
    <Pandorad@discussions.microsoft.com> wrote:

    >How do I get negative numbers in brackets if <Format<Cells<Numbers drop down
    >box does not show negative numbers in parenthesis. My spreadsheet shows
    >negative numbers with a '-' minus sign.
    >
    >Thank you
    >Sheron



  4. #4
    Pandorad
    Guest

    RE: Negative numbers in parenthesis if not shown in drop down box

    Hi Gord Dibben & Alan,

    Thanks for your earlier response. I changed the settings in control panel.
    Initially it had the '-' and it now shows (), however, my drop down box in
    numbers format still doesn't have the () and will not allow me to format
    negatives in parenthesis. Can you figure out what else I might need to do?

    Thanks so much for your help

    regards
    --
    Pandorad


    "Pandorad" wrote:

    > How do I get negative numbers in brackets if <Format<Cells<Numbers drop down
    > box does not show negative numbers in parenthesis. My spreadsheet shows
    > negative numbers with a '-' minus sign.
    >
    > Thank you
    > Sheron


  5. #5
    Gord Dibben
    Guest

    Re: Negative numbers in parenthesis if not shown in drop down box

    You changed the settings under the "Currency" tab in Regional Options?

    Gord

    On Fri, 6 May 2005 19:11:06 -0700, "Pandorad"
    <Pandorad@discussions.microsoft.com> wrote:

    >Hi Gord Dibben & Alan,
    >
    >Thanks for your earlier response. I changed the settings in control panel.
    >Initially it had the '-' and it now shows (), however, my drop down box in
    >numbers format still doesn't have the () and will not allow me to format
    >negatives in parenthesis. Can you figure out what else I might need to do?
    >
    >Thanks so much for your help
    >
    >regards



  6. #6
    Pandorad
    Guest

    Re: Negative numbers in parenthesis if not shown in drop down box

    The program is at the office so I will check on Monday. Hope that works.
    Thanks again
    --
    Pandorad


    "Gord Dibben" wrote:

    > You changed the settings under the "Currency" tab in Regional Options?
    >
    > Gord
    >
    > On Fri, 6 May 2005 19:11:06 -0700, "Pandorad"
    > <Pandorad@discussions.microsoft.com> wrote:
    >
    > >Hi Gord Dibben & Alan,
    > >
    > >Thanks for your earlier response. I changed the settings in control panel.
    > >Initially it had the '-' and it now shows (), however, my drop down box in
    > >numbers format still doesn't have the () and will not allow me to format
    > >negatives in parenthesis. Can you figure out what else I might need to do?
    > >
    > >Thanks so much for your help
    > >
    > >regards

    >
    >


  7. #7
    Pandorad
    Guest

    Re: Negative numbers in parenthesis if not shown in drop down box

    Hi Gord,

    Thank you so much for your help. I changed the setting under 'currency' and
    it worked. I'm so relieved. My spreadsheets look more professional now

    Warm regards

    --
    Pandorad


    "Pandorad" wrote:

    > The program is at the office so I will check on Monday. Hope that works.
    > Thanks again
    > --
    > Pandorad
    >
    >
    > "Gord Dibben" wrote:
    >
    > > You changed the settings under the "Currency" tab in Regional Options?
    > >
    > > Gord
    > >
    > > On Fri, 6 May 2005 19:11:06 -0700, "Pandorad"
    > > <Pandorad@discussions.microsoft.com> wrote:
    > >
    > > >Hi Gord Dibben & Alan,
    > > >
    > > >Thanks for your earlier response. I changed the settings in control panel.
    > > >Initially it had the '-' and it now shows (), however, my drop down box in
    > > >numbers format still doesn't have the () and will not allow me to format
    > > >negatives in parenthesis. Can you figure out what else I might need to do?
    > > >
    > > >Thanks so much for your help
    > > >
    > > >regards

    > >
    > >


  8. #8
    Gord Dibben
    Guest

    Re: Negative numbers in parenthesis if not shown in drop down box

    Great news.

    Thanks for the feedback.

    Gord

    On Mon, 9 May 2005 19:11:02 -0700, "Pandorad"
    <Pandorad@discussions.microsoft.com> wrote:

    >Hi Gord,
    >
    >Thank you so much for your help. I changed the setting under 'currency' and
    >it worked. I'm so relieved. My spreadsheets look more professional now
    >
    >Warm regards



+ Reply to 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