A few versions back a new feature was introduced in XBrowse:
Setting oBrw:lDisplayZeros := .f. ( default is .t.) suppresses display of zero values irrespective of the picture clause. This works just like Excel. Additional advantage is even empty dates are shown completely blank instead of as " / / "
If we want suppression of zeros only for particular columns and not for the entire browse, we can set oCol:lDisplayZeros := .f.
This setting can be changed dynamically. We can change the setting at anytime and call Refresh()