Rounding Numbers to Millions

Tweet

Excel by default does not round numbers to millions. So here's a way to tweak Excel. To round a numbers to millions: 1. Press Ctrl+1 to open the Format Cells dialog box. 2. Select the Number tab, and from Category, select Custom. 3. In the Type box, enter the following Custom Formatting syntax: #,##0,, ;[Red](#,##0,,);- ; Result: • Original number: 5,645,625 • The displaying formatted number: 6 Note: The number formatting syntax is: Positive; Negative; 0; Text Cheers! ~~SiFaR~~ http://sifar.ueuo.com