Yep. A custom format will work.

But I think the question evolved into why the parentheses don't show up in the
Negative number list box under the currency category of Format|Cells|Number tab.

wjohnson wrote:

Copy and paste this in the FORMAT CELL in the CUSTOM BOX:
#,##0_);[Red]-(#,##0.00), this was the results only in "RED"
-(5,678.00)
Just remove the [RED] if you do not want the number in red.

--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498565

--

Dave Peterson