(Tech Tip: Excel) Suppress 0 values

<span style="font-size:smallTo hide values (text or numeric) that have a 0

<

Bad: in general for your Excel sessions (independent of the file)

Tools(menu)… Options(menu)… View(tab)… Window Options(area)... Zero values(checkbox)

 

Better: You can use a formula such as

=IF(F7=0,"",F7)

 

Best: You can do it without a formula by formatting the cell with

Format(menu)… Cells(menu)… Number(tab)

Custom:   #,###_);