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.
The random number or zero result may be due to the cell contents formatted as text. Try formatting as Number or Currency (which will also give you the option to display negative numbers in red)
Edward, thanks for your help. Using your suggestion I was able to work through my problem.
Hi moonvine,
I think you need to set up properly in the import csv window, to get the right values in the sheet (clik in columns header). Seems you are getting dates and numbers as text.
To see negative numbers in red, change default cell style, F11 (Menu/Format/Styles&Formatting), right-click on Default style, select Numbers tab, where you can choose the format you like.
Mariosv, thanks for your help. Using your suggestion I was able to work through my problem