» Rounding Numbers to Millions
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
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

Book Store:
Recommended Books:
- Windows XP Pocket Reference
- Special Edition Using Microsoft Excel 2002
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Windows XP Step by Step (With CD-ROM)
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Definitive Guide to Excel VBA
No comments have been submitted.

