How to Make Excel Show Negative as Red by Default When Bringing up a CSV File

How to Make Excel Show Negative as Red by Default When Bringing up a CSV File

Release Date: 10/16/2023
Version: 7.x & Up

Q - During the Elliott 2023 conference, at the Financial Statement with Excel session, I saw you were able to bring up the CSV file in Excel that shows the negative amount with red color. I know how to manually format Excel cells to do that.  But how did you let Excel do this by default?

A - This is a natural behavior in Excel. The key is ‘$’ sign and bracket ( ). For example:

  • “   (392,229.82)” = -392.229.82     (I removed $ sign)
  • “$ (363,882.41)” = ($363,882.41)
  • Var% (without $ sign) = -34.81, -20.86   (No red ink even they are negative numbers)

See example below:




EMK/RSS


    • Related Articles

    • Feature - Prevent Excel from Dropping Leading Zeroes in CSV Item Number Field

      Release Date - 1/4/18 When exporting Elliott's item numbers to CSV through Elliott-provided reports with a CSV export option, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item ...

    • Feature - Buyer Desk Negative Target, Adjustment Pct, CSV Support

      Release Date: 8/9/21 Version: 8.5 and Above Buyer Desk will now allow the user to consider the situation where sales have slowed and the buyer should review the data to determine if they they should consider canceling existing purchase orders. In the ...

    • Feature - New Item Import Through CSV File

      Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...

    • Feature - Mass Billing By CSV Auto Select Negative Qty Ordered

      Release Date: 9/5/24 Version: 8.5 and Above A new Global Setup value has been added to COP-Func-> Billing that allows the user to specify if non-serial items with a negative quantity ordered will be automatically selected for billing if not provided ...

    • Microsoft Query Is Missing on Excel After Office 365 Update

      Release Date: 06/07/2024 Version: N/A Q: We use Microsoft Query extensively to retrieve data from Elliott database. After the last update for Office 365, my Microsoft Query is missing on Excel. How can I recover this feature? A: The solution is to go ...