Thread: [Solved] Zero (0) in cell
View Single Post
 
Old 01-18-2011, 01:16 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Windows XP Office 2003
Simulacrum
  
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default
You can use a custom format like this:

Code:
#,##0_);(#,##0);""
but, be warned, it will hide ALL zeros.

Cheers,
Reply With Quote