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,);- ;

• Original number: 9,645,625
• The displaying formatting number: 9,645.6

The number formatting syntax is:
Positive; Negative; 0; Text
Screenshot // Rounding Numbers to Thousands with Hundreds as a Decimal

More Under Finance

Posted Under

Category : Finance (3614)
Type : Articles (15999)
Tags : Excel Tips (35)

0 responses to “Excel Tips – How to round a number to thousands with hundreds shown as decimal”

  1. Asha Garge says:

    Why are the Excel Tips stopped???? It was really useful.

Leave a Reply

Your email address will not be published. Required fields are marked *