Use a custom format under format>cells>number>custom
$#,##0.00_);($#,##0.00)
(for dollars in this case) or one of the built in under
format>cells>number>currency (scroll down)
only formula would be
=TEXT(A1,"$#,##0.00_);($#,##0.00)")
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
Portland, Oregon
"jeff" <[email protected]> wrote in message
news:[email protected]...
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks