The Cynic just created a report that shows numbers in thousands, without using the old standby “/1000″ or “*.001″. See below, the value in cell C8 is 1522952.49. With the custom cell format, the cell displays 1,523.
How to?
Use the “Format Cells” menu to create a “Custom” format as follows: #,###,;(#,###,)
* Don’t accidentally overlook the comma before the semi colon or the comma before the end parenthesis.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare