Dashed Gridline

**Andy Pope** · 11-02-2011, 09:48 AM

Number format for axis and cells,

_(* #,##0_);_(* (#,##0);0;_(@_)

instead of the current one, where zero is displayed as -
_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

**pg300** · 11-02-2011, 10:41 AM

Originally Posted by Andy Pope

Number format for axis and cells,

_(* #,##0_);_(* (#,##0);0;_(@_)

instead of the current one, where zero is displayed as -
_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

Oh wow! Thanks so much! I'll go learn about custom formats now.