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.
#,##0;(#,##0);0
In case result is required in Decimals enter .00 after the zeros above.
No comments:
Post a Comment