Zero values: some on and some off

  • Thread starter Thread starter Phrank
  • Start date Start date
P

Phrank

I need to turn off the zero values for the majority of one sheet I
have, but not for all - there are two rows of cells that need to be
able to show zeros. Is there a way to do this? Thanks.

Frank
 
Format the cells you want to hide zero's with

Format/Cells/Number/Custom General;General;;@

or choose another number format instead of General.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NumberFormat for small non-zero numbers? 2
Adding recognised Zeros 5
How to count the maximum number flanked by zeros 9
Show zero values in specific area 4
TRANSPOSE results in zero values for blank cells 2
TRANSPOSE results in zero values for blank cells 4
Counting Zeros in a row until encounter first non-zero value 9
A list which don not include zero 5

Back
Top