» Rounding Numbers to Thousands
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: 5,646
Note:
The number formatting syntax is:
Positive; Negative; 0; Text
Book Store:
Recommended Books:
- Mastering Excel 2000 (for beginner)
- Adventure Capitalist: The Ultimate Road Trip
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- The One Page Business Plan: Start With a Vision, Build a Company!
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
Rounding negative numbers to thousands
Shari Garcia
This tip works for me except when the number is negative; when the number is negative, it reverts back to the original format (-7.1 = (7,083.9) ).
