If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forumla rows and columns
Why in a column do I get a (0) result from a formula in one cell in the
column and get a - for a result in the same column, different row with the same formula for each, the format for the entire column is accounting. I want all zero results in the column to be displayed as a dash (two results are (0) in the column and two other results to the same forumla show as the dash which is the correct format for accounting) -- Help !!!! |
#2
|
|||
|
|||
Forumla rows and columns
The formula result is between 0.5 and -0.5. Formatting does not alter the
real value. Wrap ROUND around your formula: =ROUND(your_formula_here,0) HTH. Best wishes Harald "Nancy" skrev i melding ... Why in a column do I get a (0) result from a formula in one cell in the column and get a - for a result in the same column, different row with the same formula for each, the format for the entire column is accounting. I want all zero results in the column to be displayed as a dash (two results are (0) in the column and two other results to the same forumla show as the dash which is the correct format for accounting) -- Help !!!! |
#3
|
|||
|
|||
Forumla rows and columns
My first thought would be to try and reformat the errant cells, thinking
perhaps that the formatting had gotten corrupted somehow. Left-click on a good cell, then Left-click on the Paintbrush in the upper toolbar, then Left-click on a "bad" cell. This will copy the formatting from the good cell to the bad cell. Vaya con Dios, Chuck, CABGx3 "Nancy" wrote in message ... Why in a column do I get a (0) result from a formula in one cell in the column and get a - for a result in the same column, different row with the same formula for each, the format for the entire column is accounting. I want all zero results in the column to be displayed as a dash (two results are (0) in the column and two other results to the same forumla show as the dash which is the correct format for accounting) -- Help !!!! |
#4
|
|||
|
|||
Forumla rows and columns
Perhaps that first 0 is returned by the formula as "0", i.e. it is a
text value, and so formatting does not change it. Alternatively, perhaps the first result is not exactly zero, but is a very small number which is rounded to 0 by the formatting you have applied. In this case you could put ROUND( ... ,2) around your existing formula, assuming you are working to 2 decimal places. Hope this helps. Pete On Dec 30, 3:51*pm, Nancy wrote: Why in a column do I get a (0) result *from a formula in one cell in the column and get a - for a result in the same column, different row with the same formula for each, the format for the entire column is accounting. *I want all zero results in the column to be displayed as a dash *(two results are (0) in the column and two other results to the same forumla show as the dash which is the correct format *for accounting) -- Help !!!! |
Thread Tools | |
Display Modes | |
|
|