Zero balance formatting. How to make appear positive 0 when value = 0 and not negative 0?

I use excel for my checkbook. When the balance is $0.00 it is displaying in RED as ($0.00). How do I get it to display as $0.00 and not in RED. Searching didn't really help as it was making negative values positive. I just want to make $0.00 appear as normal positive number.

The formula I am using is "=SUM(C5:C500)"

If I use the formula "=LOOKUP(2,1/(C:C<>""),C:C)" then it does display correctly but that is just retrieving the last value. Not the sum of the column.

Many thanks for any assistance!