Use a custom format under formatcellsnumbercustom

$#,##0.00_);($#,##0.00)

(for dollars in this case) or one of the built in under
formatcellsnumbercurrency (scroll down)

only formula would be

=TEXT(A1,"$#,##0.00_);($#,##0.00)")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"jeff" wrote in message
...