I cannot get Excel to put negative amounts in brackets. Help !

[Frustrated of Great Yarmouth]

I have tried the regional custom settings but the "apply" section is shaded
and inoperative. However the settings show negative numbers in brackets but
when I go to Excel all it does is show minus signs !! It is so terribly
frustrating.

[Backdoor Cover]

Unless your worksheet is locked by someone else for editing you should be able to just select the column or rows you want to change and then right click and format cells. In the number tab select number. You should see all the options there that will do what you need.

From your post thats all I can tell.

[Frustrated of Great Yarmouth]

The only options offered are minus signs and minus signs in red. No brackets
with numbers are offered

"Backdoor Cover" wrote:

>
> Unless your worksheet is locked by someone else for editing you should
> be able to just select the column or rows you want to change and then
> right click and format cells. In the number tab select number. You
> should see all the options there that will do what you need.
>
> From your post thats all I can tell.
>
>
> --
> Backdoor Cover
> ------------------------------------------------------------------------
> Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
> View this thread: http://www.excelforum.com/showthread...hreadid=376069
>
>

[Jeff Beecham]

"Frustrated of Great Yarmouth" wrote:

> I have tried the regional custom settings but the "apply" section is shaded
> and inoperative. However the settings show negative numbers in brackets but
> when I go to Excel all it does is show minus signs !! It is so terribly
> frustrating.

[Jeff Beecham]

Sorry about the mix up with my previous posting.

To put negative amounts in brackets do the following:

Hightlight the cell your working in.
Format
Cells
Custom
Type the following in the space at the top: 0.00_);(0.00)

You will now be able to show negative amounts in brackets in that cell only.

Regards

Jeff Beecham Colchester




>
>
> "Frustrated of Great Yarmouth" wrote:
>
> > I have tried the regional custom settings but the "apply" section is shaded
> > and inoperative. However the settings show negative numbers in brackets but
> > when I go to Excel all it does is show minus signs !! It is so terribly
> > frustrating.

[David McRitchie]

or if you want red and you want thousands separated by a comma
#,##0.00_);[Red](#,##0.00)
#,###.00_);[Red](#,###.00)

What version of Excel and in what language are you using?
You might want to feed a search into Google like since I don't
remember where the problem was I'll leave the exact search to you
excel 2000 accounting format* parenthes* French
There might be a setting you can use that solves the problem.

http://www.mvps.org/dmcritchie/excel/formula.htm#comma
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jeff Beecham" <[email protected]> wrote in message news:[email protected]...
> Sorry about the mix up with my previous posting.
>
> To put negative amounts in brackets do the following:
>
> Hightlight the cell your working in.
> Format
> Cells
> Custom
> Type the following in the space at the top: 0.00_);(0.00)
>
> You will now be able to show negative amounts in brackets in that cell only.
>
> Regards
>
> Jeff Beecham Colchester
>
>
>
>
> >
> >
> > "Frustrated of Great Yarmouth" wrote:
> >
> > > I have tried the regional custom settings but the "apply" section is shaded
> > > and inoperative. However the settings show negative numbers in brackets but
> > > when I go to Excel all it does is show minus signs !! It is so terribly
> > > frustrating.

[edrobbie]

I totally agree!!! This problem has been extant for years and Microsoft
cannot be ignorant of it. I, too , have tried every which way to display
negatives numbers in red and in brackets. It's a snap in Quattro Pro and in
Lotus. For crying out loud, MS, FIX IT ONCE AND FOR ALL!!!!

"Frustrated of Great Yarmouth" wrote:

> I have tried the regional custom settings but the "apply" section is shaded
> and inoperative. However the settings show negative numbers in brackets but
> when I go to Excel all it does is show minus signs !! It is so terribly
> frustrating.