Hi Gordon,

Thanks for your speedy response! You have answered my question.
FYI - in accounting, Assets and Expenses are Debit Accounts and Liabilities
and Equity are Credit Accounts. This is necessary in order for your Trial
Balance to zero-out so you can do financial statements and income statements.

"Gord Dibben" wrote:

Credits are generally positive values.

Don't enter numbers with a negative value in the credit column.

Enter those in your debit column.

Or am I missing some detail?

If you wanted negative values to show as positive, in a helper column enter

=ABS(cellref)


Gord Dibben MS Excel MVP


On Thu, 5 Jul 2007 13:42:03 -0700, AvonSue
wrote:

I am creating a spreadsheet with debit and credit columns. How do I format
the Credit column so all entries automatically post as a credit?