| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyphen (nit minus) in cell | Excel Discussion (Misc queries) | |||
| Trying to use IF statement with hyphen | Excel Worksheet Functions | |||
| Optional hyphen? | Excel Discussion (Misc queries) | |||
| Entering a hyphen into a cell | Excel Worksheet Functions | |||
| many numbers in one cell separated by hyphen. | Excel Discussion (Misc queries) | |||
Linear Mode
