Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views :
    Excel formulas and tutorials

    Excel formulas and useful tools

    Home / Excel / Formatting / Format cell to show numbers in thousands

    Format cell to show numbers in thousands

    /
    /
    /
    828 Views

    Sometimes it is useful to round numbers to the nearest 1000 in order to obtain a good looking report. That is, to have many small width columns and get them all on the same page when printing.

    Formatting cells to show thousands

    1. Right click on the cell you want to format
    2. Select Format cells….
    3. From Category choose Custom
    4. In the Type area write #,##0, ;[Red](#,##0,);-

    format cell show numbers in thousands 1000

    You have now the format you need. Additionally it turns the font red when the cell contains negative numbers.

    The drowback of this formatting is that when the numbers are added manually the total may differ from the exact one, as the numbers behind the rounding are hidden away.

    Have fun with Excel!

     
    • Facebook
    • Twitter
    • Google+
    • Linkedin
    • Pinterest

    Leave a Comment

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

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    This div height required for enabling the sticky sidebar