software

Use a custom format under formatgt;cellsgt;numbergt;custom

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

(for dollars in this case) or one of the built in under
formatgt;cellsgt;numbergt;currency (scroll down)

only formula would be

=TEXT(A1,quot;#,##0.00_);(#,##0.00)quot;)

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;jeffquot; gt; wrote in message
...
gt;