| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I show zero in Accounting format ?
I want to show the zero in my spread sheet not the dash but want to also show
the $ sign. Any ideas.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I show zero in Accounting format ?
Not sure really what you what but this might work
=IF(A1="","$0.00",A1) "Jakesmom" wrote: I want to show the zero in my spread sheet not the dash but want to also show the $ sign. Any ideas.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I show zero in Accounting format ?
If you format the cell (showing the hyphen), then use:
Format|Cells|number tab you'll see that the custom format is: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) You could change it to: _($* #,##0.00_);_($* (#,##0.00);_($* 0.00_);_(@_) If you want to fix all the cells formatted with the Currency style, you could use: Format|Style|Select Currency Click Modify and change the numberformat to what you like. Be aware that styles live in workbooks. You'll have to do the same thing for each workbook that needs it. Jakesmom wrote: I want to show the zero in my spread sheet not the dash but want to also show the $ sign. Any ideas.... -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom accounting format | Excel Discussion (Misc queries) | |||
| Currency vs. Accounting Format | Excel Worksheet Functions | |||
| Accounting Category Display does not show the correct format/outpu | New Users to Excel | |||
| accounting format for zero show 0.00 in one cell "-" in another | Excel Discussion (Misc queries) | |||
| Display 0's in Accounting format | Excel Discussion (Misc queries) | |||
Hybrid Mode
