» 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:
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Business Analysis with Microsoft Excel (2nd Edition)
- The Interpretation of Financial Statements
- Marketing Plan: A Handbook with Marketing Plan
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Investing for Dummies, Third Edition
"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.
