IS it possible not to display zeros from all the sheets

[#1]

Hi Friends,

Is it possible not to display ZEROS in all the pivot tables I created in different sheets at time.

Thank

[amit_saini]

Pavan,

Try this:

=if (isnull(Your_field)),'',Your_field)

thanks,
AS