formula for parenthesis round negative money values in excel
|
formula for parenthesis round negative money values in excel
Use a custom format under formatcellsnumbercustom
$#,##0.00_);($#,##0.00) (for dollars in this case) or one of the built in under formatcellsnumbercurrency (scroll down) only formula would be =TEXT(A1,"$#,##0.00_);($#,##0.00)") -- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "jeff" wrote in message ... |
All times are GMT +1. The time now is 12:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com