Excel 2007

[camioneur]

Is it possible to format a cell to "accounting", and have a "�" symbol that only shows in the cell if there is a value in the cell more than zero? The cell must also retain a formula. I've tried all sorts and the best I can do is retain the formula but the "�" shows in all the cells even if they have no value, any help appreciated

[rojash]

Go to Cells/Format/Format Cell
Choose custom
In the section "type", paste the following line

_-�* #,##0.00_-;-�* #,##0.00_-;_* " "??_-;_-@_-

[camioneur]

Well rojash that works just fine, I daren't ask how that comes about but thanks anyway