Grab the column or cell that you want to show this formatting,
Right click and go to format cells.
Go to custom and enter the following custom option in the Type: box :
0.00" CR";0.00 " DR";0.00
Or indeed just cut and paste it from here into the box.
That will append CR if positive and DR if negative and nothing for zero values
I just love Excel questions.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
