Change appearance of a negative #

Is there a way to change the format of a cell to make a negative number llok different?

Example: original# -123.50
Change to: 123.50CR

Perhaps custom format as:

0.00;0.00C\R;-;@

this also replace 0's with a dash....

You could perhaps use a Custom Format ? eg:

#,##0.00"DR";#,##0.00"CR";0.00;@

Maybe should've been


0.00;0.00"CR";-;@

this also replace 0's with a dash....