Custom Number fort

[u088129]

Format a cell to display following correctly:
a dollar value when >zero, the value followed by "CR" when <zero, and "No charge" when zero.

My format is as follows:
$0.00;<$0.00"CR";0.00;"No Charge"@

 

[Oaktree]

Welcome to the board.

I'm not too sure what you mean. Maybe you can let us know how you'd like each of these formatted:

+1234.765
-1234.765
0
SomeTextHere

 

[barry houdini]

Format a cell to display following correctly:
a dollar value when >zero, the value followed by "CR" when < zero, and "No charge" when zero.

My format is as follows:
$0.00;<$0.00"CR";0.00;"No Charge"@

Try

$0.00;$0.00"CR";"No Charge"

 

[u088129]

Thank you, will try