P
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
$#,##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