Hello,

I'm hoping this should be easily fixed? Basically I just need to know how
(if?) you can get negative numbers to appear in brackets, rather than having
a minus '-' sign in front of the figure.

Thanks

Use a format (menu FormatCellsCustom) of

#,##0;(#,##0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"IoHeFy" wrote in message
...
Hello,

I'm hoping this should be easily fixed? Basically I just need to know how
(if?) you can get negative numbers to appear in brackets, rather than
having
a minus '-' sign in front of the figure.

Thanks

If you just want that format (with the ()'s) to show up in the samples in
format|Cells|Number tab...

Excel picks this up from a windows setting:

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.

IoHeFy wrote:

Hello,

I'm hoping this should be easily fixed? Basically I just need to know how
(if?) you can get negative numbers to appear in brackets, rather than having
a minus '-' sign in front of the figure.

Thanks

--

Dave Peterson

And just so there's no confusion for others reading this thread, I
assume you meant to say "parentheses", not "brackets", correct?

These are parentheses ( )
These are brackets [ ]
These are braces { }

Hello, Paul!
You wrote on 26 Oct 2006 05:06:21 -0700:

PDS And just so there's no confusion for others reading this
PDS thread, I assume you meant to say "parentheses", not
PDS "brackets", correct?

PDS These are parentheses ( )
PDS These are brackets [ ]
PDS These are braces { }

That certainly is common usage but is by no means universal and
accepted! People even use other things as brackets. The theorist
Paul Dirac had a rather useful notation in quantum mechanics
called the braket notation; < was a "bra" and a "ket".

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

Hi James,

Yes, now that you mention it, I have seen people refer to the greater
than and less than symbols as brackets, too (and come to think of it,
commonly so).

I've also seen people refer to braces - { } - as "curly" braces
(are there "non-curly" braces lurking around somewhere?) If we're to
call them "curly" braces, then why not "curved" parentheses and
"squared" brackets?

But then, how many times do we see people on this group erroneously
refer to VBA as just VB? (VB is one thing; VBA is something else).
(Drives me crazy!)

Anyway...

So now, if I'm getting this correctly, parentheses can be referred to
as brackets, and the greater than and less than symbols can be referred
to as brackets. So, just out of curiosity, what do people refer to
these as?: [ ]

Paul

Hello, Paul!
You wrote on 26 Oct 2006 07:28:28 -0700:

PDS So now, if I'm getting this correctly, parentheses can be
PDS referred to as brackets, and the greater than and less
PDS than symbols can be referred to as brackets. So, just out
PDS of curiosity, what do people refer to these as?: [ ]

Square brackets! :-)


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not