Cell format - put hyphen where zero value would be.
 

I am working on an expenses spreadsheet, and I have the category of expenses
in column A. In the cells that would carry the numerical values, how do I
format the cell to show a hyphen where a value would eventually be,
indicating that the present value in the cell is zero?

Cell format - put hyphen where zero value would be.
 

Maybe this.......
Format for Custom, then
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)

or

_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)

The cell must have a zero in it for the hyphen to show up.

Vaya con Dios,
Chuck, CABGx3




"sheana" wrote:

I am working on an expenses spreadsheet, and I have the category of expenses
in column A. In the cells that would carry the numerical values, how do I
format the cell to show a hyphen where a value would eventually be,
indicating that the present value in the cell is zero?

Cell format - put hyphen where zero value would be.
 

FormatCellsNumberAccounting


Gord Dibben MS Excel MVP

On Fri, 1 Feb 2008 03:41:01 -0800, sheana
wrote:

I am working on an expenses spreadsheet, and I have the category of expenses
in column A. In the cells that would carry the numerical values, how do I
format the cell to show a hyphen where a value would eventually be,
indicating that the present value in the cell is zero?