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?