Hi,
with custom format you will see the numbers as negatives, in your formulas
you will need to treat them as positives for example if you enter 1 in cell
A1 and you format it to be seen as -1, then in B1 you enter =A1 it will show
as 1 (positive) if you want to be shown as negative you have to enter =-A1

"EarthAngel" wrote:

I used custom format so that I could automatically enter several negative
numbers without keying in the minus sign each time. However the column did
not calculate correctly. What else can I try.