Hi,
Try formatting the cells in Excel itself, select the Number tab, Custom
and then select #,##0;(#,##0)
hope that works for you
--
penri0_0
------------------------------------------------------------------------
penri0_0's Profile:
http://www.excelforum.com/member.php...o&userid=28947
View this thread:
http://www.excelforum.com/showthread...hreadid=545418