Let's say we have -567,987
I want it to be showed in bracket and round to the nearest thousand:: (568,000)
All I know now is that for the bracket we may use #,##0;(#,##0);0
and ##,##0,",000" to round number to nearest thousand.
I had try to alter & combine it, no Luck.
Thanking you in advance.
Bookmarks