Add "accounting indent" to blank zero number format

[Matt C]

Hi folks



Is there any way of adapting this number format:

#,##0_);(#,##0)

...so that it hides zero values? I've been using:

0;-0;;@

...but when it returns a value greater than "0" the alignment is too close to the right-hand cell border and the figures don't align correctly as there is no indent.

Can anyone help?

Thanks, Matt

[xor]

#,##0_);(#,##0);

[Matt C]

Thank you - much appreciated.