Search This Blog

November 15, 2011

To display Brackets for negative figure in Excel

Right Click on desired Cell >Format Cells >Number and select Custom and enter as below:-

#,##0;(#,##0);0

In case result is required in Decimals enter .00 after the zeros above.

No comments:

Post a Comment