I'm working on a balance sheet.
One column is always going to be negative numbers, while another column will always be positive numbers, the end column will always be the resulting balance.
I want to make it so you dont have to type a "-" in front of every negative number.
How can I make/format a cell so that any number inside that cell is considered a negative number, without having to type the "-" everytime?
I need to keep the layout as shown below.

A | B | C | D | E | F | G
Date | Type | Description | Deduct | X | Add | Balance

The above line actualy starts on line 9. So only cells D9 and higher (D10,D11,D12,D13, etc. to end of page) will need to be negative.

Anyone know how to do this?

I figured out one way to do it.
In the balance column cell for each line I added a "-" in front of the "D" cell.
Example (Cell G11): =SUM(G10,-D11,F11)

If anyone knows another way please post.

you can:

option 1- set up a column to multiply raw number by -1. Example cell A1 is raw number, cell A2 is =SUM(A1*-1). Do the same for B1 and B2, then you can highlight A2 and B2, move mouse to lower right hand corner of B2 and drag all the way down however many rows you need. When you enter a raw number in A column it will automatically show as a negative number in B column. You can hide A column when you print.

Option 2- Leave raw number as a positive until you do the summation.
For example your final answer column is D, cell D1 would be:
=SUM((A1*-1)+B1). Cell D2 would be: =SUM((A2*-1)+B2).

Here again you can highlight cells D1 and D2, move the mouse to lower right hand corner and drag down as many rows as you need.

thanks