Missing data show as ....

Hi 

I have a scorecard measuring revenue. I have missing data set to "show 0" ... I need it to show as £0, as it feeds into other charts which now aren't calculating correctly. 
Any ideas how to make this happen?

Thanks -- MIKE

0 1 101