» Rounding Numbers to Thousands with Hundreds as a Decimal
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
To round a number to thousands with the hundreds shown as a decimal: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.0, ;[Red](#,##0.0,);- ;
Result:
• Original number: 5,645,625
• The displaying formatting number: 5,645.6
Note:
The number formatting syntax is:
Positive; Negative; 0; Text

Book Store:
Recommended Books:
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Microsoft Windows XP Registry Guide
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Special Edition Using Microsoft Access 2002
- Financial Peace: Revisited
No comments have been submitted.

