Formatting cells

Hi Anjali

Thanks for getting in touch. There's no direct one-click answer to make this happen in Excel. If your data is in a PivotTable there are options to format zeroes and errors as you require.

For regular cells, you can wrap the contents in a formula, but it can get a little messy and may not be the simplest approach. You would have a formula like this:

=IF(OR(ISERROR(your formula),0),"n/a",your formula)

If it is too cumbersome to modify the sheet to incorporate this formula, would Conditional Formatting help? You may wish to format all zeroes or errors as white or another format.

There's more info at this Microsoft link:

http://office.microsoft.com/en-gb/excel-help/hide-error-values-and-error-indicators-in-cells-HP003056121.aspx

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector