Cell format - put hyphen where zero value would be.

S

sheana

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?
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Excel does not accept text format! 0
Would like to input 3 letters into a cell, each having a different numerical value 5
How to display zero value in blank fields of Cross Tab query 0
VBA Coding Help for Beginner 0
DOCPROPERTY field switches and non-breaking hyphens and spaces 5
Add numbers if cell fill is a certain color; How To? 5
Copy addition formula of non-consecutive horizontal cells 2

Top