» 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:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Excel Charts
- Writing Excel Macros with VBA, 2nd Edition
- Microsoft Excel Version 2002 Step by Step
"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.
