A filed with Numeric format designated to store amount cash dividends paid in currency format. This field, however, for sometime is empty if there was no dividends was paid. But keeping the field empty might be misleading for the user. I decided to replace the empty value with "No Dividends for This Year". Becuase the field is in currency format I can't show the text in it.
Is there a way to make the field shows a text if the value is empty without afecting the numeric values for other years that table.