Display £ sign in cell only if less / more than 0

[IanJS]

My apologies if this is really basic stuff

I have for instance a cell (C3) that is format as accounting £ . The cell contents are A3+B3
If cells A3 and B3 are both blank C3 still displays £
Is there a way to format C3 to not display £ unless A3 or B3 have info

appreciated

Ian

[6StringJazzer]

I suppose it could be done with formatting but might be more straightforward to just update your formula:

Please Login or Register  to view this content.

[shg]

The format of the cell looks something like this:

_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)

The third item in the semicolon delimited list is how zero is displayed. If you want nothing displayed, change it to this:

_($* #,##0_);_($* (#,##0);;_(@_)

[TMS]

Change the Accounting Custom Format from this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.