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 100
1 REPLY 1

Hi,

You can add the pound sign as an image and not format the number directly.