Zero (0) in cell

		Microsoft Office Forums > Microsoft Excel > Excel
Zero (0) in cell

01-18-2011, 01:16 PM

ConneXionLost ConneXionLost is offline

Windows XP Zero (0) in cell

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

You can use a custom format like this:

Code:

#,##0_);(#,##0);""

but, be warned, it will hide ALL zeros.

Cheers,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM
Help reg Protection of cell.	aligahk06	Excel	1	09-02-2009 05:45 PM
Cell formatting	Niko	Excel	5	04-23-2009 12:05 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:09 PM.