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 - 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 ...

    • 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 - Plus WO Operation Number Default Increment

      Release Date - 10/2/17 This feature allows the user to specify the increment used when copying a routing when creating a Plus Work order. They system currently always uses a value of 10. New options have been added to BOMP Global Setup that allow the ...