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?

Display Zero Values in Only Select 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?

Display Zero Values in Only Select 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

Display Zero Values in Only Select Cells
 

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

Display Zero Values in Only Select Cells
 

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

Display Zero Values in Only Select Cells
 

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