close
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;
全站熱搜
留言列表
