Forum Discussion
Negitive numbers
Simply select the desired column and use below formatting to convert numbers as negative.
You may also refer to the attached file for more clarity.
Thanks
Tauqeer
You could also just use =ABS(D6) and copy that formula down. That takes any number, positive or negative, and makes it positive.
As I said in my first post, I find it a lot more meaningful to just know which fields are debits and which are credits and deal with them accordingly in any mathematical calculations. To show a debit as a negative is in itself kind of a double negative (given that the word means, in a way, that it's a negative).
By the way, why do you have multiple sheets? In my own workbook for tracking income and expenses, I have a single transactional database, incorporating the statements from every bank account and every credit card. It does mean that I have to do some operations on some of them to ensure a standard way of dealing with debits and credits--there is no industry standard--but once done, a single Pivot Table summarizes them all, income and expenses, by month and by category.