I was using Excel 2003 on XP and when I entered a negative Currency or
Accounting number -1,235.00 in a cell it appeared automatically in brackets
(1,235.00), after I hit enter. I am now using Excel 2007 on Vista and when I
do the same, the number appears with a negative sign -1,235.00.

What can I do to make negative Currency or Accounting numbers appear in
Excel as (1,235.00) automatically?

If you want the ()'s to show up for negative numbers in the format|cells|number
tab, you'll have to change 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.

Accountant wrote:

I was using Excel 2003 on XP and when I entered a negative Currency or
Accounting number -1,235.00 in a cell it appeared automatically in brackets
(1,235.00), after I hit enter. I am now using Excel 2007 on Vista and when I
do the same, the number appears with a negative sign -1,235.00.

What can I do to make negative Currency or Accounting numbers appear in
Excel as (1,235.00) automatically?

--

Dave Peterson