My bank provides the ability to download my monthly credit card statements in CSV format. I load these into Calc and categorize my expenses for taxes and budget comparison. I’m using Calc 4.1.x and win 8.1. I’m using a function such as =sum(a1:a20). The usual total result is the value in a1 or some random number or zero.
In addition I cannot get negative numbers to display in red. The are preceded by a minus sign.
Suggestions or other help will be appreciated.