thanx for the same.

Really informative.

I try to explain the custom format string. kindly refer this link

I hope this will explain you why we need to use format symbols in custom format string. (this covers adding debit/credit text with the values entered in a cell)

Good thinking it will look better if you add "IF" condition

=IF(G6-I6=0," ",+K5+G6-I6)

in balance colume it will show blank if amount is not enter in G or I Colume