» 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:
- Marketing Plan: A Handbook with Marketing Plan
- Financial Reporting and Analysis (2nd Edition)
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Financial Modeling - 2nd Edition
- Financial Risk Manager Handbook, Second Edition
- Special Edition Using Microsoft Outlook 2002
"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.
