» Rounding Numbers to Millions
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
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:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- The Analysis and Use of Financial Statements
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The Fall of Advertising and the Rise of PR
"Rounding" numbers to millions
Gretchen
Just a slight concern with the term ROUNDING ... the number is NOT rounded to millions ... it is only FORMATTED in millions. The number in the cell remains the original number (5,645,625) and if used in a formula the results will represent the original number, not the "rounded" number.
