• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

5 Easy steps to display positive or negative values in Excel using custom number formatting

By admin on June 23, 2016April 19, 2019

In order to effectively analyze data, custom number formatting can be applied to your Microsoft® Excel® spreadsheet. Custom number formatting is used to easily identify values based on a set criteria. In a large Excel spreadsheet, you can easily highlight all negative or positive values by using custom number formatting.
In this example we are going to display all negative values in a different colour.
You are welcome to download the workbook to practice.
Applies To: Microsoft® Excel® 2010, 2013 and 2016.
1. Select the range of cells which need to be formatted. For this exercise, we’ll use cells B1:B8 in the workbook.
2. Hold down the Ctrl and 1 keys simultaneously or right click, and select the Format Cells
3. Click on the Custom option under the Category section.

4. Select the # ##0; [Red] – # ###0 option from the Type list . The two parts are separated with a semicolon (;) to control positive and negative numbers only. Values to the left of the semicolon represent positive values and values which are to the right of the semicolon, represent negative values.
5. To remove the negative sign from the value displayed, the number format code must be adjusted by removing the sign from the format code as follows
With “– “
# ##0; [Red] – # ###0
Without “– “
# ##0; [Red] # ###0

All negatives values are highlighted in red, making it easy to work with figures that have variances. This will save you time of manually selecting all the negatives values and increase productivity.
The post 5 Easy steps to display positive or negative values in Excel using custom number formatting appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

4 Easy steps to auditing complex formulas in Excel
Learn how to create a performance profile for all your Sage Intelligence reports

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd