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
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
Try custom formatting
#,##0;"("#,##0")"
to display a negative value as (20) or
#,##0;-"("#,##0")"
to display -(20)
Regards,
"Pandorad" <[email protected]> wrote in message
news:[email protected]...
> 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
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"
<[email protected]> 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
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
You changed the settings under the "Currency" tab in Regional Options?
Gord
On Fri, 6 May 2005 19:11:06 -0700, "Pandorad"
<[email protected]> 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
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"
> <[email protected]> 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
>
>
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"
> > <[email protected]> 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
> >
> >
Great news.
Thanks for the feedback.
Gord
On Mon, 9 May 2005 19:11:02 -0700, "Pandorad"
<[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks