display blank instead of #

HI Eperts,

If any characteristic have # value and in report output or in workbook it is being displayed as # or 'not assigned'.

now can I display a blank space instead of # in my workbook output?

Also make me clear regarding the usage of conditions in BEx Query Designer.

Regards,

Vishal.