How to Format Debits and Credits in Excel. When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance.