| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accounting format returns a - for zero other cells show 0.0 Why?
Cell format set to accounting returns a - for zero. The sample box also shows
-. On other cells with accounting format 0.00 is returned and the sample box shows 0.00. How can the sample be changed to give me a consistent format? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show zero in Accounting format ? | Excel Worksheet Functions | |||
| Format Cells - Accounting - Discrepancy? | Excel Discussion (Misc queries) | |||
| 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) | |||
| How do I get brackets in format cells accounting? | Excel Discussion (Misc queries) | |||
Threaded Mode
