Always Subtracting in a Column

B

Bons

is there a way to tell a column that if it sees a number it should be
reflected as a minus? I'm doing deposits in one column and checks in
another, with the total in the third. I've got the formulas in place and it
works great---but I have to put a minus sign in every time----is there a way
to avoid that step? Thanks for any light anyone can shed on this---This
discussion group is the BEST---I've learned TONS here!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tell a column to always subtract --Excel 2003 4
Table column text disappears at page end and does not continue on next page 2
CSV file conversion + True/False over multiple columns of data 1
No shortcut keys/key combinations tocalculate (add, subtract) in Word 2008? 18
Subtract 1 random no. in col from another without naming cells? 3
Anti-virus, -spam measures in OL2002? 4
Locate text in range (multiple occurrences) and report other cell insame column? 25
convert column headings 4

Top