formula for parenthesis round negative money values in excel

[Peo Sjoblom]

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