» 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:
- Business Analysis with Microsoft Excel (2nd Edition)
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Microsoft PowerPoint Version 2002 Step by Step
- Financial Peace: Revisited
"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.

