OK, im working on a school project and it is to make a checkbook register with the common credit and debit columns. We are given the values to enter and supposed to make the debit column show in parentheses and in red automatically, without entering a - in front of the entries. I cannot use the number dialog box as I dont have - in front, only tip teacher gave is use a formula at top of column.
example of debit entry 124.18, no - sign, no dollar sign.
please help, im going insane.
excel 2007