Display Zero Values in Only Select Cells

I have an extemely large spreadsheet with sheets for each month and a summary
sheet.
In only a small percentage of the cells (<1%) I would like to display zero
values. The remaining cells I do not want zeros so I have set
Tools<Options<View<Zero Values to NO. Is there a way to override the
Options<Zero Values for a select few cells?

add a space behind the 3rd argument (zero value display)
in a custom numberformat e.g.

'General;General;0 '

don't enter the apo's



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


MikeElectricUtility wrote :

> I have an extemely large spreadsheet with sheets for each month and a
> summary sheet.
> In only a small percentage of the cells (<1%) I would like to display
> zero values. The remaining cells I do not want zeros so I have set
> Tools<Options<View<Zero Values to NO. Is there a way to override the
> Options<Zero Values for a select few cells?

Or
General;-General;0

(the lack of a trailing space didn't seem to bother it.)

keepITcool wrote:
>
> add a space behind the 3rd argument (zero value display)
> in a custom numberformat e.g.
>
> 'General;General;0 '
>
> don't enter the apo's
>
> --
> keepITcool
> | www.XLsupport.com | keepITcool chello nl | amsterdam
>
> MikeElectricUtility wrote :
>
> > I have an extemely large spreadsheet with sheets for each month and a
> > summary sheet.
> > In only a small percentage of the cells (<1%) I would like to display
> > zero values. The remaining cells I do not want zeros so I have set
> > Tools<Options<View<Zero Values to NO. Is there a way to override the
> > Options<Zero Values for a select few cells?

--

Dave Peterson

You Guys Rule! I always get the answers I need from this discussion board!!

Originally Posted by MikeElectricUtility

You Guys Rule! I always get the answers I need from this discussion board!!

Yes I agree. Dave and KeepITcool from where do you manage to get such beautiful ideas? I don't see these tips documented at all. Yes you guys rule!!

A V Veerkar

I get mine from hanging out in the newsgroups!

avveerkar wrote:
>
> MikeElectricUtility Wrote:
> > You Guys Rule! I always get the answers I need from this discussion
> > board!!
>
> Yes I agree. Dave and KeepITcool from where do you manage to get such
> beautiful ideas? I don't see these tips documented at all. Yes you guys
> rule!!
>
> A V Veerkar
>
> --
> avveerkar
> ------------------------------------------------------------------------
> avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
> View this thread: http://www.excelforum.com/showthread...hreadid=511831

--

Dave Peterson