Excel 2003 - brackets not always available 1

[LoganTeamX]

It's turning out to be a very weird day.

I have Office 2003 SBE and Office 2003 Pro, both SP2, scattered around our office. When Accounting formats their cells, they want negative values and totals to show up in red numbers and bracketed. On some, but not all, machines... red and bracketed negative values aren't available. This is independent of SBE and Professional versions of Office 2003. The only similar option is red and prepended with a minus sign. Commonality amongst computers is preferred, obviously.

Is there somewhere to go within Excel itself to make this available? Right-click --> Format Cells... --> Currency or Numeric is where we have these options.

Thanks in advance.

 

[AnotherHiggins]

You could choose Custom under formatting, then enter the following:

_($* #,##0.00_);[red]_($* (#,##0.00);_($* "-"??_);_(@_)

The first argument tells Excel how to display if positive,
the second argument (after the semicolon) tells Excel how to display if negative, and the last tells Excel how to display if zero.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[LoganTeamX]

Thank you! So far that looks promising. I'll be testing this tomorrow with some of the involved parties.